Copying a MySQL database FAST

Kimball Larsen kimball at kimballlarsen.com
Tue Aug 5 22:50:22 MDT 2008


On Aug 5, 2008, at 8:46 PM, Dave Smith wrote:

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

Would it be possible to set up 2 instances of mysql on the machine?   
Each gets its own data dir, and copying from one db to another could  
still use rsync to localhost.

Just a thought.

Good luck.

-- Kimball





More information about the PLUG mailing list