On Tuesday 04 March 2003 22:34, Andrew Braithwaite wrote: > This is quite an involved one... > > Using MySQL 4.0.11 on linux > > I have two logical db's on the same machine, lets say db1 and db2. > > I have perl apps doing the following: "replace into db2.tablename ....." > > In my.cnf I have the line "binlog-do-db = db1" > > The queries are being performed OK on db2, but they're being included in > the replication bin-log. > > I also have inserts in the similar form of "insert into db2.tablename > ....." that work fine and don't show up in the same bin-log! > > Any ideas? Is this a bug?
No, it's not a bug. >From the manual: Tells the master that it should log updates to the binary log if the current (i.e. selected) database is 'database_name'. All others databases which are not explicitly mentioned are ignored. Note that if you use this you should ensure that you only do updates in the current database. So, if your current database is db1 and you do REPLACE on db2 this command is also written to the binary logs. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
