In case you’re using MySQL Workbench for creating dumps please keep in mind that version 6.3.5 has one annoying bug.
After update, the first time I tried do create dump, the complete process failed with the next error:
... mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE' ... |
As I can see, this error occurs on various systems (Windows / MAC / Linux) and it was fixed once (6.1.x was also affected – LINK)
For now, you can only apply temporarily fix:
Open file (as root) wb_admin_export_options.py (located in /usr/lib/mysql-workbench/modules for Ubuntu/Mint/Debian distros)
Find the line
"delayed-insert":["Write INSERT DELAYED statements rather than..." |
and insert # at the begin of this line (to comment it out)
Save file and restart Workbench. Check the Advanced option and note that this option is not available
Note: Windows users
For 32bit systems, wb_admin_export_options.py is located in C:\Program Files\MySQL\MySQL Workbench XXX\modules
For x64 systems, wb_admin_export_options.py is located in C:\Program Files (x86)\MySQL\MySQL Workbench XXX\modules)
The bug fix is easy to apply but it was announced months ago we’re still waiting for update… So shame…
More info:
http://stackoverflow.com/questions/20128223/export-data-from-mysql-workbench-6-0
https://bugs.mysql.com/bug.php?id=72312