Bug #15245 Can't adjust multiple databases with binlog-do-db and binlog-ignore-db
Submitted: 25 Nov 2005 14:42 Modified: 4 Mar 2011 17:32
Reporter: Mickael Besson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.2.14 OS:Windows (Windows XP pro SP2)
Assigned to: Maksym Yehorov CPU Architecture:Any

[25 Nov 2005 14:42] Mickael Besson
Description:
Impossible to adjust multiple databases in the fields binlog-do-db and binlog-ignore-db.

How to repeat:
Startup variables / Log Files / Log updates for
Startup variables / Log Files / Ignore updates for

Suggested fix:
listbox with buttons + and -
or
DB names separated with a comma
[4 Nov 2008 13:33] Susanne Ebrecht
Many thanks for writing a bug report. This is already fixed in our actual version MySQL Administrator 1.2.14. There you can fill in the database by using comma as separator.
[5 Nov 2008 14:26] Susanne Ebrecht
Many thanks for pointing out this. We made a longer research and tests here. This is still an issue for MySQL Administrator. You can separate different databases with comma in Administrator but it won't work as expected.
[6 Mar 2009 13:10] Yannis Aglamisis
Any progress on this issue?

The same problem exists with replicate-ignore-table (when comma separated values are specified, they are ignored, so the tables are replicated)

The obvious fix is to convert from comma separated list to multiple entries in my.ini when applying changes, and from multiple entries to comma separated list when reading entries from my.ini
[15 Oct 2009 5:58] Susanne Ebrecht
It needs to be checked if this is working in Workbench
[19 Oct 2009 13:54] Susanne Ebrecht
Bug #40502 is set as duplicate of this bug here.
Bug #47683 is set as duplicate of this bug here.
[26 Jan 2010 9:10] Maksym Yehorov
For using comma:
To specify multiple databases you must use multiple instances of this option. 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. http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replic...

To specify multiple instances of the option | character can be used in Workbench. When text is typed into the option entry field and | symbol detected WB asks if you want multiple options or leave as it is. After that the option will be written as multi-instances option. The same is true for the reverse operation, when multi-instance option is detected in an option file it is parsed into <value1> | <value2> | .... | <valueN>.
[26 Jan 2010 10:35] Maksym Yehorov
Symbol | as a separator is replaced with ;
I know that this is a flawed solution, but the nice-looking one is scheduled ahead.
Thanks for the report.
[23 Mar 2010 17:50] Johannes Taxacher
fixed in repository
[4 Mar 2011 17:32] Tony Bedford
An entry has been added to the 5.2.17 changelog: 

In the configuration settings panel of the Administrator, the ',' character 
was treated as part of the database name, and so it was not possible to 
specify multiple databases for certain configuration options. 

MySQL Workbench has been changed as follows: 

Several configuration options allow multiple databases to be specified. For 
example, binlog-do-db and binlog-ignore-db. However, if a comma is used to 
delimit these databases, the comma is correctly treated as part of the 
database name. This means, in order to specify multiple databases you must 
use multiple instances of the option. 

To specify multiple instances of the option, the “;” character can be used in 
MySQL Workbench. When text is typed into the option entry field and the “;” 
symbol detected, MySQL Workbench prompts you to select multiple instances, or 
leave the option entry unchanged. If selected the option will be written to 
the configuration file as multiple instances. Further, when a multiple 
instance option is detected in a configuration file it is parsed into 
<value1> ; <value2> ; ... ; <valueN>.