From: Eric Bergen
Date: March 11 2005 4:09pm
Subject: Re: Replication only DB
List-Archive: http://lists.mysql.com/mysql/181171
Message-Id: <11b1bd99050311080950bb5515@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Remember replicate-do-db doesn't look at queries to decide which ones
to replicate. It only looks at the USE flag. This is very important:

<manual snip http://dev.mysql.com/doc/mysql/en/replication-options.html>
 Tells the slave to restrict replication to statements where the
default database (that is, the one selected by USE) is db_name. To
specify more than one database, use this option multiple times, once
for each database. Note that this does not replicate cross-database
statements such as UPDATE some_db.some_table SET foo='bar' while
having selected a different database or no database. If you need
cross-database updates to work, make sure that you have MySQL 3.23.28
or later, and use --replicate-wild-do-table=db_name.%.
</manual snip>

-Eric


On Fri, 11 Mar 2005 09:36:53 -0600, Peter Brawley
<peter.brawley@stripped> wrote:
> replicate-do-db came in with 3.23.16, and it's in the manual (though the
> online search engine mishandles a search for 'replicate-do-db'--look
> under 'Replication startup options').
> 
> PB
> 
> -----
> 
> Steve Buehler wrote:
> 
> > At 02:35 AM 3/11/2005, you wrote:
> >
> >> You can simply specify the database:
> >>
> >> --replicate-do-db=db_name
> >
> >
> > Stupid/Not so Stupid question here.  What mysql program has that
> > option?  I searched mysql.com and couldn't find it.  I have looked at
> > the man pages for mysql, mysqld, mysqladmin and mysqldump and didn't
> > see it as an option to any of them.  I also googled for
> > --replicate-do-db and --replicate-to-db (incase you misspelled it).
> > Still nothing.  Can you give me/us a hint?
> >
> > Thanks
> > Steve
> >
> >
> >
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net