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 Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0.41 OS:Linux
Assigned to: CPU Architecture:Any

[5 Feb 2008 21:15] Dave Rose
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


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:


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.