Without local access to the server, is there any way to duplicate/clone a MySQL db (with content and without content) into another without using mysqldump
?
I am currently using MySQL 4.0.
Without local access to the server, is there any way to duplicate/clone a MySQL db (with content and without content) into another without using mysqldump
?
I am currently using MySQL 4.0.
I can see you said you didn't want to use mysqldump
, but I reached this page while looking for a similar solution and others might find it as well. With that in mind, here is a simple way to duplicate a database from the command line of a windows server:
db2
is the target database, where the source database db1
will be copied.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]
http://stackoverflow.com/questions/25794/mysql-copy-duplicate-database