Live Help


Skype Chat
Yahoo Chat

Client portal

VPS Service

Cloning Database

May 2, 2013     0 comments

To clone database in shortest time, try the following:
1. Create the target database using MySQLAdmin or your preferred method. In this example, db2 is the target database, where the source database db1 will be copied.
2. Execute the following statement on a command line:
mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2

Note: There is NO space between -p and [password]

How helpful was this article to you?

cPanel Partner NOC