I was hoping to going to sleep early tonight, but I discovered a bug with mySQL 5.6 and the Workbench tool. I used the latest releases since last week. No problems at all for importing data or working on databases and tables.
There’s a problem if you try to export your tables:
when you try to dump your tables, you get this
/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump is version 5.5.24, but the MySQL Server to be dumped has version 5.6.10-log.
Because the version of mysqldump is older than the server, some features may not be backed up properly.
It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server.
The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool:
If you proceed you’ll probably get:
mysqldump: Couldn’t execute ‘SET OPTION SQL_QUOTE_SHOW_CREATE=1′: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_QUOTE_SHOW_CREATE=1′ at line 1 (1064)
I searched google for 30 minutes, then as someone told that the mysqldump version was wrong, and that he got different versions of that file in his system (under Linux I think) I searched for the mysqldump file.
I found one in the mySQL Workbench app folder (/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump) , and one inside the mySQL Server folder (/usr/local/mysql/bin/mysqldump). Different creation dates… So I opened the WB and I went to Preferences > Administrator > Path to mysqldump tool, and I added this:
After that, my dump went smooth as silk, no more errors.
I hope that helps until a fixed WB tool!