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
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
