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: [email protected] [mailto:[email protected]] On Behalf Of Baron Schwartz Sent: Tuesday, December 23, 2008 8:11 AM To: Bryan Irvine Cc: [email protected] 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/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
