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. > This provides some interruption to service, but nothing like a stop/start.
But there's a race condition on a busy MySQL server when you use LOAD DATA to kickstart replication. What if tables are modified all the time? The *only* way to get a consistent image is to lock ALL of them at the same time. mysqlsnapshot will do that for you: http://jeremy.zawodny.com/mysql/mysqlsnapshot/ Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 207,455,614 queries (399/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
