List:Replication« Previous MessageNext Message »
From:Timo Date:April 2 2010 5:51pm
Subject:回复: CREATE TABLE didn't replicated inside do-db database
View as plain text  
Hi lisa:



This is the bug of version 5.0.37.

If you run 'create db.table', the slave will not to replicate the table. You should run 'use db; create table'. And  version 5.0.90 has fixed this bug.

2010-04-02



Best regards
Timo Seven
blog: http://zauc.wordpress.com
#####请翻ystem Admin & MySQL DBA



发件人: Database System <database100@stripped>
发送时间: 2010-04-02 00:20
主 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 




       

--  
MySQL Replication Mailing List 
For list archives: http://lists.mysql.com/replication 
To unsubscribe:    http://lists.mysql.com/replication?unsub=greycd@stripped 
Thread
回复: CREATE TABLE didn't replicated inside do-db databaseTimo1 Apr
  • Re: 回复: CREATE TABLE didn't replicated inside do-db databaseDatabase System1 Apr
  • Re: CREATE TABLE didn't replicated inside do-db databaseHai Zhang6 Apr
    • Re: CREATE TABLE didn't replicated inside do-db databaseMiguel Angel Nieto3 May