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.%.
On Fri, 11 Mar 2005 09:36:53 -0600, Peter Brawley
> 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').
> 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=1