Re: replication w/o stopping the master

2003-08-14 Thread Jeremy Zawodny
On Tue, Aug 05, 2003 at 02:14:11PM +0100, [EMAIL PROTECTED] wrote: > > See the command LOAD DATA FROM MASTER ( > http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER.html ). This should do > what you want - it does it for me. > As I understand it, this puts a read lock on each table as it copies it.

Re: replication w/o stopping the master

2003-08-05 Thread Alec . Cawley
See the command LOAD DATA FROM MASTER ( http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER.html ). This should do what you want - it does it for me. As I understand it, this puts a read lock on each table as it copies it. This provides some interruption to service, but nothing like a stop/start.