Bug #60256 Mac Workbench Export Query: File Path Failed to Open File
Submitted: 25 Feb 2011 17:45 Modified: 16 May 2011 19:21
Reporter: Mike Reid Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.31 OS:MacOS (OSX v10.6.6 / MySQL v5.1.53)
Assigned to: CPU Architecture:Any
Tags: export, file, path, query, workbench

[25 Feb 2011 17:45] Mike Reid
When exporting a record set to an external file, the Export will fail if the File Path is not absolute. For example, to manually type the path "~/export.csv" will not resolve the "~" to home directory.

How to repeat:
1. Open Workbench
2. Connect to database
3. Run a query: SELECT VERSION();
4. Click the "export recordset" button
5. Manually enter "~/export.csv" as the file path
6. Click "Export"
7. Get error: Failed to open output file: `~/export.csv`

Suggested fix:
Add support for unix "~" (home directory) in File Path.
[16 May 2011 19:21] Paul DuBois
Noted in 5.2.34 changelog.

Record set export to a file failed unless the file name was given as
an absolute path name.