MySQL Bugs: #49036: WB directory chooser results in invalid Windows path

Bug #49036	WB directory chooser results in invalid Windows path
Submitted:	24 Nov 2009 16:04	Modified:	8 Dec 2009 10:20
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.2 r4753	OS:	Windows (XP)
Assigned to:	Maksym Yehorov	CPU Architecture:	Any

Description:
Using WB to edit a configuration file for MySQL 5.0.67 (although surely version independent) on Windows XP, I use the directory chooser to select the Data directory.  Originally, my.ini had the following:

datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

This is a valid path for Windows.

After using the directory chooser in WB to choose the same directory, I end up with the following, which is not a valid Windows path:

datadir = C:\Program Files\MySQL\MySQL Server 5.0\data

This causes the MySQL server to be unable to start.

How to repeat:
Use the directory chooser to select a path for datadir.
Use the resulting my.ini file to try to start MySQL.

Suggested fix:
Use appropriate Windows path.

Fixed.
Added quoting to filedialog results in config section.

path are enclosed in quotes now. fix will be included in 5.2.11

An entry has been added to the 5.2.11 changelog:

In the General tab of the configuration editor, changing the data directory using the file chooser control led to an invalid directory being introduced into the MySQL configuration file. This prevented the MySQL Server from starting.