回复: CREATE TABLE didn't replicated inside do-db database

[Timo]

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