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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
