uclajatt uclajatt - 15 days ago 7
MySQL Question

Cloning a MySQL database on the same MySql instance

I would like to write a script which copies my current database

sitedb1
to
sitedb2
on the same mysql database instance. I know I can dump the sitedb1 to a sql script:

mysqldump -u root -p sitedb1 >~/db_name.sql


and then import it to
sitedb2
.
Is there an easier way, without dumping the first database to a sql file?

Answer

As the manual says in Copying Databases you can pipe the dump directly into the mysql client:

mysqldump db_name | mysql new_db_name

If you're using MyISAM you could copy the files, but I wouldn't recommend it. It's a bit dodgy.

Comments