Bug #54445 MySQL workbench inserts invalid directory into my.ini
Submitted: 11 Jun 2010 20:54 Modified: 16 Jun 2010 16:42
Reporter: Matt Mayfield Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.22 OSS RC OS:Windows (XP SP3)
Assigned to: Maksym Yehorov CPU Architecture:Any

[11 Jun 2010 20:54] Matt Mayfield
Description:
Under Admin, configuration, General. Changing the "Temp directory" using the "..." button inserts the path name using Windows syntax, e.g. with backslashes. Changing the temp directory to "c:\temp", for example, causes the My SQL server to crash on startup, presumably because it thinks the temporary directory is "c:(tab)emp". Overtyping the "\" in the path with a forward slash "/" corrects the problem.

How to repeat:
1. In My SQL workbench, select a server from "Server Administration"
2. Select the "Configuration (Edit configuration file)
3. The "General" tab is selected by default.
4. Click the check box next to "Temp directory:" if not already selected.
5. Click on the "..." browse button to select a directory.
6. The directory appears in the text box with a back slash.
7. Apply the changes. The preview will show something like:
 Changed: [mysqld] tmpdir = "C:\temp"
8. Click on the "Startup (Start/stop the server)" on the ribbon.
9. Click on the "Stop Server" to stop the server and then after it has stopped, click on "Start Server". The server will fail with no obvious error message:
2010-06-11 14:47:45 - Trying to start server...
2010-06-11 14:47:47 - 
2010-06-11 14:47:47 - Checked server status: Server is stopped. 

Suggested fix:
When the Workbench is writing directory information to the my.ini file on a windows box, backslashes should be converted to forward slashes. Alternately if for some reason having escapes as part of the file names is important, then perhaps when the "..." browsing button fills in the text box containing the selected directory name the conversion should be done at that point.
[12 Jun 2010 7:43] Susanne Ebrecht
Is the auto fill also not working?
[12 Jun 2010 12:13] Matt Mayfield
"Is the auto fill also not working?" I'm not sure what you mean by auto fill. If you're refering to the textbox containing the directory name being filled in with the result of the folder selection dialog box, then that is exactly what the problem is: the textbox has the folder name filled in with a backslash separator.
[13 Jun 2010 14:07] Valeriy Kravchuk
Verified just as described on Windows XP SP3.
[15 Jun 2010 15:37] Maksym Yehorov
This was fixed.
[15 Jun 2010 18:21] Johannes Taxacher
fix confirmed in repository
[16 Jun 2010 16:42] Tony Bedford
An entry has been added to the 5.2.23 changelog:

In the General tab of Configuration in the Administrator, when the Temp directory option was selected, and a directory selected using the file browser, MySQL Workbench inserted backslashes rather than forward slashes. If backslashes were used in this location in the configuration file, the server crashed on startup.