uclajatt uclajatt - 1 year ago 68
MySQL Question

Cloning a MySQL database on the same MySql instance

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

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
Is there an easier way, without dumping the first database to a sql file?

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download