Bug #47683 mysql-administrator does not support multiple binlog-ignore-db
Submitted: 28 Sep 2009 16:40 Modified: 28 Sep 2009 16:50
Reporter: Thierry de Villeneuve Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:5.0r12 OS:Any
Assigned to: CPU Architecture:Any
Tags: binlog-ignore-db, mysql-administrator, startup parameters

[28 Sep 2009 16:40] Thierry de Villeneuve 
Description:
I had the following in my manually edited /etc/my.cnf

binlog-ignore-db	= mysql
binlog-ignore-db	= test
binlog-ignore-db	= phpmyadmin

Saving changes made with mysql-administrator "Startup Parameters" editor changed my /etc/my.cnf into this

binlog-ignore-db=phpmyadmin
binlog-ignore-db=phpmyadmin
binlog-ignore-db	= phpmyadmin

At http://dev.mysql.com/doc/refman/5.1/en/replication-options-binary-log.html
it is said the following:

To specify more than one database to ignore, use this option multiple times, once for each database. Because database names can contain commas, if you supply a comma separated list then the list will be treated as the name of a single database.

Rgds,
Thierry

How to repeat:
a/ Create/edit your /etc/my.cnf and make a backup copy

b/ Enter binlog-ignore-db options multiple times

c/ Open mysql-administrator

d/ Make some changes and save your changes

e/ Now diff the /etc/my.cnf with the backup done in a/

Suggested fix:
Allow the editing of multiple binlog-ignore-db setup options
[28 Sep 2009 16:50] Susanne Ebrecht 
This is a duplicate of bug #40502
[19 Oct 2009 13:55] Susanne Ebrecht 
This is a duplicate of bug #15245