I have a database named
#text#.xx which I need to ignore in replication. According to mysql:
The rules for escape sequences in option files differ slightly from the rules for escape sequences in string literals in SQL statements. In the latter context, if “x” is not a valid escape sequence character, \x becomes “x” rather than \x.
So I set my my.cnf to:
binlog-ignore-db = test binlog-ignore-db = "#"text"#".xx replicate-ignore-db = "#"text#.ssh
But interestingly after restarting mysql I observe: mysql> show master status;
... Binlog_Ignore_DB ... test,"#"text"#".xx
The expectation is to see the
Binlog_Ignore_DB equal to
test,#text#.xx. Should I be concerned?
By the way
#comments out the rest of the line)
\, again anything after
#will be commented out.
”, but they definitely mean