Copying a MySQL database FAST

Dave Smith 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.

--Dave



More information about the PLUG mailing list