> 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.
I have an array of test cases that says otherwise. I just connected to one of my masters, inserted a record into a table by referencing database.table in the insert query and the query is never written to the binary log, thus the slaves never replicate it. However, if I type: \u database ...and then do the insert query it's written to the binary log fine, and of course picked up by the slaves. Similarly when using mysql via Php, if I don't use mysql_select_db() and instead, simply use mysql_query() and specify the database.table in the sql string passed to it, the query is never written to the binary log. --------------------------------------------------------------------- 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
