Alle Wednesday 12 May 2004 16:14, Egor Egorov ha scritto:
> 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?
>
>
>
mysql-4.0.18-max on both sides.
this is the configuration of the slave:
[mysqld]
log-bin
server-id=2001
master-host=master
master-port=3306
master-user=replica
master-password=****************
replicate-ignore-db=mysql
master-connect-retry=60
slave-skip-errors=all
replicate-do-db=db
replicate-wild-do-table=db.%
replicate-wild-do-table=dbsetting.db%
replicate-wild-do-table=image_repository.db%
replicate-wild-do-table=workflow.table_categories
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
