The problem with this idea is that mysql replication doesn't always work so you'd end up with data missing from the backup. If you don't explicitly select or 'use' a database, the sql query is never written to the binary log and thus the slaves don't pick it up.
----- Original Message ----- From: "Joseph Bueno" <[EMAIL PROTECTED]> To: "Philip Mak" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 7:36 PM Subject: Re: How to backup without blocking? > Hi, > > You can also use mysql replication: you install a slave server and > run mysqlhotcopy on it. This way, you never freeze the master server. > > Hope this helps > Joseph Bueno --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
