Copying a MySQL database FAST

Dave Smith dave at thesmithfam.org
Tue Aug 5 17:28:46 MDT 2008


I need to copy a MySQL database fast. Let's pretend it's for backup 
purposes, and the user is impatient. The database has about 15,000,000 
rows spread non-uniformly across 30 InnoDB tables. I've tried mysqldump, 
like so:

   mysql -u root -e "create database new_db"
   mysqldump -u root old_db | mysql -u root new_db

But it takes about an hour.

Unfortunately, mysqlhotcopy is not an option either since it only works 
with ISAM and MyISAM tables.

Any other ideas? I need some speeeeeed....

--Dave



More information about the PLUG mailing list