More investigation shows that the query does make it to the slave, at least into the relay log, yet it's still ignored. 'replicate-do-db' is set and shows the correct DB in the slave status.
Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 20 Oct 2005, Atle Veka wrote: > I ran into a problem on a replication setup, where if you issue the > following CREATE statement on the master the table will get created and > the query entered into the binlog, however the slave ignores it silently: > CREATE TABLE `db`.`table` (a INT DEFAULT 0) > > I have duplicated this exact issue on several different setups, one > running 4.0.24 on both the slave and master. Is this by design, is it a > bug, or? > > The manual states > (http://dev.mysql.com/doc/refman/5.0/en/create-table.html): > "In MySQL 5.0, the table name can be specified as db_name.tbl_name to > create the table in a specific database. This works whether or not there > is a current database. If you use quoted identifiers, quote the database > and table names separately. For example, `mydb`.`mytbl` is legal, but > `mydb.mytbl` is not." > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]