Hello.
Manual says that --replicate-do-db:
Tells the slave to restrict replication to statements where the
default database (that is, the one selected by USE) is db_name.
Note that this does not replicate cross-database statements, check
what is your default database, when you're running
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
Hello.
the query entered into the binlog, however the slave ignores it silently:
Check your server's relay logs if they contains this statement. See:
http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html
http://dev.mysql.com/doc/refman/5.0/en/slave-logs.html
Check that
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