Copying a MySQL database FAST
dave at thesmithfam.org
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