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()
are executed. That's why yesterday I posted my patch to mysqldump
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
