Bug #2622 Replication fails when using replicate-do-db and replicate-wild-ignore-table

• Submitted: 3 Feb 2004 1:23
• Modified: 3 Feb 2004 6:31
• Reporter: Tommi Berg
• Status: Not a Bug
• Category: MySQL Server: Replication
• Severity: S2 (Serious)
• Version: 4.0.17
• OS: SunOS
• CPU Architecture: Any

[3 Feb 2004 1:23] Tommi Berg

Description:
Replication doesn't work when using my.cnf like,
replicate-do-db = db1
replicate-do-db = db2
replicate-wild-ignore-table = %.%

But it works with,
replicate-wild-do-table = db1.%
replicate-wild-do-table = db2.%
replicate-wild-ignore-table = %.%

This is a bug because in http://www.mysql.com/doc/en/Replication_Options.html is stated that do-db is priority 1 and wild-ignore-table is priority 6. There weren't any cross database updates.

How to repeat:
Use my.cnf like
replicate-do-db = db1
replicate-do-db = db2
replicate-wild-ignore-table = %.%

[3 Feb 2004 6:31] Guilhem Bichot

Hi,
Sorry, what you experience is consistent with the section of the manual which you pointed:
you said Replication doesn't work when using my.cnf like,
replicate-do-db = db1
replicate-do-db = db2
replicate-wild-ignore-table = %.%
If the table is db1.t, first rule is matched but the manual says that other rules will then be tested. Please re-read in full detail the section of the manual.