MySQL Bugs: #25690: not all data gets replicatied.

Bug #25690	not all data gets replicatied.
Submitted:	18 Jan 2007 9:40	Modified:	20 Jan 2007 18:36
Reporter:	morten kallesoee	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	4.1.22	OS:	Linux (Linux 2.6 Debian)
Assigned to:		CPU Architecture:	Any
Tags:	replicate_ignore_db, replicate-do-db, replicate-wild-ignore-table, replication

Description:
Replication setup;
1 master with 2 databases. "databaseA" and "databaseB"
1 slave with the options;
replicate_do_db=databaseA
replicate_ignore_db=databaseB
replicate-wild-ignore-table=databaseB.%

How to repeat:
use databaseB
insert into databaseA.table values (data)

The query will not be executed on the slave into databaseA

Suggested fix:
only put data in the database you are working on

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read carefully how option replicate-do-db works at http://dev.mysql.com/doc/refman/4.1/en/replication-options.html