Copying a MySQL database FAST

Dave Smith dave at
Tue Aug 5 20:46:39 MDT 2008

Jeff Schroeder wrote:
> Dave asked:
>> I need to copy a MySQL database fast.
> If the servers (source and destination) are on the same LAN, you might 
> consider using rsync.

I'm actually copying the contents of one database to another on the 
*same* MySQL server, so rsync is not an option. Doubly so because the 
tables are all InnoDB so the two DB's share data in a common directory.


More information about the PLUG mailing list