Bug #71928 Error Checking mysqldump version with exporting table

• Submitted: 4 Mar 2014 17:51
• Modified: 19 Jun 2014 20:42
• Reporter: Bill Tucker
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.0.9
• OS: MacOS (OSX 10.9.2)
• CPU Architecture: Any
• Tags: Data Export, mac, mysqlworkbench, osx

[4 Mar 2014 17:51] Bill Tucker

Description:
When attempting to export a table data from MySQL database version 5.6.15 on Mac OSX. Each time I attempt to preform the export I get an error message Error Checking mysqldump Version Could not parse version number from /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump: Warning World-writable config file '/etc/my.cnf' is ignored mysqldump version 10.13 for osx 10.7 (x86_64). Just as FYI, I can import data fine.

I have tried to copy the mysqldump from the MySQL directory to the MySQLWorkbench directory but that did not work. I also tried to set the directory in the Preference screen and set to the MySQL installation to no avail. I have search and searched for a fix to this issue and no luck with that approach.

Now the one thing to note is upgraded my MySQLWorkbench recently to the 6.0.9 version. I have to admit that I never tested this functionality on Mac prior to this report. I did test this functionality on Windows 7 system using the same MySQLWorkbench version and it worked without issue.

How to repeat:
In the workbench select "Data Export" the select a database schema. Then deselect all tables and select a single table to export. Select Start Export button and the error message will appear and the export is not allowed due the error. On the Export Progress screen you see the following:

WARNING
Error checking mysqldump version
Could not parse version number from /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump:
Warning: World-writable config file '/etc/my.cnf' is ignored
mysqldump  Ver 10.13 Distrib 5.6.15, for osx10.7 (x86_64)

[4 Mar 2014 20:23] MySQL Verification Team

warning message mysqldump

Attachment: mysqldump_version.png (image/png, text), 48.85 KiB.

[4 Mar 2014 20:30] MySQL Verification Team

Thank you for the bug report.

[6 Mar 2014 19:34] Alfredo Kojima

Bill, you should fix the permissions to your my.cnf file, your setup is insecure.
Please execute sudo chmod o-x /etc/my.cnf and try again

[6 Mar 2014 21:19] Bill Tucker

Alfredo, thank you for the response. The my.cnf in the /etc directory is currently set (insecure) to -rwxrwxrwx basically 777.

[6 Mar 2014 23:16] Alfredo Kojima

Does it work after fixing that?

[6 Mar 2014 23:17] Alfredo Kojima

Sorry, meant sudo chmod o-w /etc/my.cnf

[7 Mar 2014 0:10] Bill Tucker

Change error message on export after chmod o-w /etc/my.cnf

Attachment: Screen Shot 2014-03-06 at 4.10.16 PM.png (image/png, text), 35.62 KiB.

[3 Jun 2014 20:30] Alfredo Kojima

Do you have some database called --8 ?

[3 Jun 2014 23:12] Bill Tucker

I no longer work at the company and I no longer have a mac with MySQL running. Please close this ticket as I will not be able to work with the team.

[19 Jun 2014 20:42] Alfredo Kojima

Closing as unable to repeat (was verified incorrectly) and original reporter is no longer available.