I set up replication for 1 database with binlog_do_db
setting.
But there are some queries like:
USE replicated_db;
DELETE not_replicated_db.table;
Which breaks replication (with an error about not_replicated_db is not existing on the slave)
How I can ignore not_replicated_db.table
queries?
I tried to change binlog_format from MIXED to ROW/STATEMENT but it didn't affect it.