| Bug #31756 | binlog-ignore-db is ignored in certain cases | ||
|---|---|---|---|
| Submitted: | 22 Oct 2007 15:36 | Modified: | 22 Oct 2007 16:08 |
| Reporter: | Dominik Jungowski | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 4.1.11 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | binlog-ignore-db ignored | ||
[22 Oct 2007 16:08]
Hartmut Holzgraefe
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
Description: When you execute a query like "INSERT INTO db1.table" but are not currently using db1, the query will be replicated, even though db1 is set to be ignored How to repeat: Set up a replication and set binlog-ignore-db = mysql now go to the mysql console on the master and type the following: mysql> use test; mysql> INSERT INTO mysql.user (User) VALUES ('foobar'); now the statement is replicated, even though the database is set to be ignored for the replication