Alle Wednesday 12 May 2004 21:51, hai scritto:
> 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
I can't reproduce it anymore, I must have made something wrong that messed up
the replication sooner.
Sorry and thanks for your help,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
