On Fri, Dec 06, 2002 at 07:51:54PM +1000, Jason Brooke wrote: > > The problem with this idea is that mysql replication doesn't always > work so you'd end up with data missing from the backup.
What? I've never had that happen. If it does, it's a bug. File a bug report if it's not documented as "this doesn't work with replication." > 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. I have a test case that says otherwise. I just connected to my master, inserted a record into a table (never having done a USE), and then checked a slave. It was there as expected. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 16 days, processed 491,528,980 queries (340/sec. avg) --------------------------------------------------------------------- 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
