[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: replication of databases
From:       "Bryan Irvine" <sparctacus () gmail ! com>
Date:       2008-12-23 16:26:06
Message-ID: 53d706300812230826q356f7483od9f22e757964c2c1 () mail ! gmail ! com
[Download RAW message or body]

On Mon, Dec 22, 2008 at 6:40 PM, Baron Schwartz <baron@xaprb.com> wrote:
>>> 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.
>

Indeed it was a gap in my understanding.  That did the trick!  Many thanks!!

-Bryan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]