Copying a MySQL database FAST
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
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.
More information about the PLUG