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
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
