Nico Sabbi <[EMAIL PROTECTED]> wrote: > Alle Wednesday 12 May 2004 14:12, hai scritto: >> > > >> > > > 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() > > are executed. That's why yesterday I posted my patch to mysqldump >
Works fine for me. Do you use any other replication-* options? Which version of MySQL server do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]