Unable to export database in MySQL Workbench – delayed-insert error

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:

Leave a Reply

Your email address will not be published. Required fields are marked *