Hi! On May 12, Nico Sabbi wrote: > Alle Wednesday 12 May 2004 14:12, hai scritto: > > Hi! > > > > On May 12, Nico Sabbi wrote: > > > Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto: > > > > Hi! > > > > > > > > > sorry for replying to myself, but I verified that adding > > > > > replicate-do-db=db to my.cnf doesn't work as I expected > > > > > > > > What do you mean - it doesn't work ? > > > > Or, rather, how do you expect it to work ? :) > > > > > > I expect the slave servers to execute insert statements related to the > > > database "db" that they have in their binlog (that I can see), both when > > > they are in the form > > > > > > insert into db.table values() > > > > > > and when they show as: > > > > > > use db; > > > insert into table values() > > > > > > but this doesn't happen: the directive replicate-wild-do-table=db.% seems > > > to control the behaviour of the slaves, so they only executes statements > > > like insert into db.table values() > > > > > > This behavior breaks replication when I use > > > mysqldump -h local -a -B db | mysql -h master > > > > Yes, but the second syntax (with use db) should replicate if you use > > replicate-do-db=db. I understood that you tried it, and it didn't work ? > > Exactly. > In my.cnf I have both: > > replicate-do-db=db > replicate-wild-do-table=db.% > > but only > > insert into db.table values()
First - sorry for confusion, according to http://dev.mysql.com/doc/mysql/en/Replication_Options.html replicate-do-db is not expected to do anything if you have replicate-wild-do-table. So you are right - it does not work as you expected. But replicate-wild-do-table should work, no matter whether you use insert into db.table values() or use db; insert into table values() Could you provide a repeatable test case to show that replicate-wild-do-table does not work ? If yes - please submit it at http://bugs.mysql.com/ Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]