MySQL Bugs: #49299: only shows last replicate-do-db entry

Bug #49299	only shows last replicate-do-db entry
Submitted:	1 Dec 2009 21:22	Modified:	22 Jan 2010 16:29
Reporter:	Miguel K	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2	OS:	Windows
Assigned to:	Maksym Yehorov	CPU Architecture:	Any

Description:
If there are more than one "replicate-do-db" lines in the config file such as:
replicate-do-db = data1
replicate-do-db = data2

The Administrator only shows the second one from the config file.  It should show both.

How to repeat:
Add these two lines to my.ini:
replicate-do-db = data1
replicate-do-db = data2

View: Startup Variables>Replication tab

Suggested fix:
Show both, separated by a comma, in the same way that "show slave status" does. 

(This might cause problems if the comma is a legal character in a schema name.  If so, then I recommend displaying it as a multi-line text box, so you could update the list of schemas from the Administrator interface.)

Thank you for the bug report.

Many thanks for writing a bug report.

We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench.

Lots of Adminstrator functionality already is supported from Workbench 5.2.

Anyway, this should work in Workbench.

We will fix this in Workbench.

Fixed

this has been fixed.
to separate the database names in the textfield, use the pipe character '|'.
will be included in 5.2.13

An entry has been added to the 5.2.13 changelog:

If the server configuration file contained more than one entry for replicate-do-db, then the configuration editor on the Admin tab only displayed the second entry, rather than both.