Bug #22590 Instance Manager: Incorrect dumping of option values to the configuration file
Submitted: 22 Sep 2006 13:45 Modified: 5 Oct 2007 15:19
Reporter: Alexander Nozdrin Email Updates:
Status: Unsupported Impact on me:
None 
Category:Instance Manager Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[22 Sep 2006 13:45] Alexander Nozdrin 
Description:
Instance Manager does not dump values of options into
the configuration file correctly. The problem occurs
when option value contains spaces or symbols to be quoted.

The problem seems to be serious, because it is critical
for Windows to handle pathes like "C:\Program Files" correctly.

How to repeat:
mysql> create instance mysqld50112 basedir="/var/a space/a'quote/a#hash/";
Query OK, 0 rows affected (0.05 sec)

And this is what gets written to the configuration file:

[mysqld50112]
basedir=/var/a space/a'quote/a#hash/

No quotes.  But they are needed. Depending on the quoting character
used, the ' might need escaping.

Other escaping needs to occur as well:

mysql> create instance mysqld50111 basedir="\\C:\\Program Files";
Query OK, 0 rows affected (0.05 sec)

This is what appears in the configuration file:

[mysqld50111]
basedir=\C:\Program Files
[5 Oct 2007 15:19] Konstantin Osipov 
Setting to Unsupported unless the decision to discontinue is reverted.