List:General Discussion« Previous MessageNext Message »
From:Sergei Golubchik Date:May 12 2004 12:12pm
Subject:Re: How to dump data in db.table syntax?
View as plain text  
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 <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com
Thread
How to dump data in db.table syntax?Nico Sabbi11 May
  • Re: How to dump data in db.table syntax?Egor Egorov11 May
    • Re: How to dump data in db.table syntax?Nico Sabbi11 May
      • Re: How to dump data in db.table syntax?Nico Sabbi11 May
        • Re: How to dump data in db.table syntax?Sergei Golubchik12 May
          • Re: How to dump data in db.table syntax?Nico Sabbi12 May
            • Re: How to dump data in db.table syntax?Sergei Golubchik12 May
              • Re: How to dump data in db.table syntax?Nico Sabbi12 May
                • Re: How to dump data in db.table syntax?Egor Egorov12 May
                  • Re: How to dump data in db.table syntax?Nico Sabbi12 May
                • Re: How to dump data in db.table syntax?Sergei Golubchik12 May
                  • Re: How to dump data in db.table syntax?Nico Sabbi13 May