Copying a MySQL database FAST
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,
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....
More information about the PLUG