Copying a MySQL database FAST
kirksemail at gmail.com
Wed Aug 6 07:51:41 MDT 2008
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
On Tue, Aug 5, 2008 at 10:50 PM, Kimball Larsen
<kimball at kimballlarsen.com> 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.
More information about the PLUG