Could you set up the second machine as a Slave using MySql replication and then replicate the data over to the other box in real time without taking down MySql, And then stop the replication? This would make a backup without bringing down mysql. Unless you have to bounce it to start and stop replication.
Kirk Cerny On Tue, Aug 5, 2008 at 10:50 PM, Kimball Larsen <[EMAIL PROTECTED]> wrote: > 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. > */ > /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
