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.
#####请翻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.
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe: http://lists.mysql.com/replication?unsub=greycd@stripped