Bug #34333 wildcard character different for command line versus /etc/my.cnf

• Submitted: 5 Feb 2008 21:15
• Modified: 5 Feb 2008 22:10
• Reporter: Dave Rose
• Status: Can't repeat
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.0.41
• OS: Linux
• CPU Architecture: Any

[5 Feb 2008 21:15] Dave Rose

Description:
I was trying to set up replication filtering on a slave, and could not get it to work. I was using the docs at: http://dev.mysql.com/doc/refman/5.0/en/replication-options.html

I put the following in my /etc/my.cnf

replicate-wild-do-table=db2.%

Thus thinking ANY statement for db1.% would be ignored, but when I started the slave I would get an error saying that db1 table did not exist. 

Quite simply it was fixed by specifying:

replicate-wild-do-table=db2.*

So the wildcard character % does not work in /etc/my.cnf

I am assuming that it works fine on the command line?

ie) --replicate-wild-do-table

How to repeat:
Try filtering replication by using % in either replicate-wild-do-table or replicate-wild-ignore-table

Suggested fix:
make % an acceptable wildcard character in /etc/my.cnf

[5 Feb 2008 22:10] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior.