Hi, In your case replication will reflect only the changes done by selecting the default db as mysql as the binlog_do_db parameter is set to mysql.
Regards Sonal -----Original Message----- From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of Baron Schwartz Sent: Tuesday, December 23, 2008 8:11 AM To: Bryan Irvine Cc: mysql@lists.mysql.com Subject: Re: replication of databases >> Right. Unless you have some other settings (binlog-do-db or >> binlog-ignore-db on the master?) that are interfering You saw this ^^^^^ right? > on master: > mysql> show master status; > +------------------+----------+--------------+------------------+ > | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | > +------------------+----------+--------------+------------------+ > | mysql-bin.000122 | 98 | mysql | | > +------------------+----------+--------------+------------------+ > 1 row in set (0.00 sec) You need to read up on what binlog_do_db means. And you shouldn't use it. It is the problem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sonal.ragh...@honeywell.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
