I saw this in the manual comments on
http://www.mysql.com/doc/R/e/Replication_Options.html:
================
: Note that if you client does not do a "USE dbname", binlog-do-db=dbname will not
:binlog a query like: "update in dbname.foobar set foo=1" You explicitly have to do a
:USE before a query in order to
have your query binlogged, it looks like. Replication on the slave side can do
wildcard matches .. but the master cannot (a la binlog-wild-do-table=dbname.%). So
make sure your clients do a use, if you
plan to replicate those tables it updates.
================
Is this still true in the latest version of MySQL? Is
this behaviour by design?
Cheers,
Ollie
--
Oliver Cook Systems Administrator, ClaraNET
[EMAIL PROTECTED] 020 7903 3065
---------------------------------------------------------------------
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