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 ?
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]
