From: Rick James
Date: April 1 2010 6:34pm
Subject: Re: CREATE TABLE didn't replicated inside do-db database
List-Archive: http://lists.mysql.com/replication/1865
Message-Id: <4BB4E722.4020408@yahoo-inc.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Replication is filtered based on the USE statement before the given 
statement.  Perhaps this caused filtering?

On 4/1/10 9:19 AM, Database System wrote:
> Hi,
>
> I found CREATE TABLE on master didn't replicated to slave. On slave server ini file, I have replicate-do-db = db_name. When new table is created in this database, it didn't replicated to slave. Updating on exist tables are replicated.
>
> On a different server, slave didn't setup replicate-do-db, the CREATE TABLE was replicated to slave. The privilege on replication account is the same.
>
> The version I use is V5.037.
>
> Any ideas?
>
> Thanks,
> Lisa
>
>
>
>
>
>
>