mysqldump: [ERROR] unknown variable 'delayed-inser

This error occurs on various systems and can be temporarily fixed by:

1. Going to the appropriate directory depending on the system:

   a) Windows: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules (32-bit installation on x64 systems: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules)

   b) Mac OS X: Applications/MYSQLWorkbench.app/Contents/Resources/plugins - right click on the app and select Show Package contents to get inside the app (thanks to Bradley Flood)

   c) Linux Ubuntu: /usr/lib/mysql-workbench/modules (thanks to Alessandro Lopes)

2. Open file wb_admin_export_options.py

3. Find line "delayed-insert":["Write INSERT DELAYED statements rather than ...

4. Insert # at the begin of this line to comment it out

5. Save file and restart Workbench.

Tested on Windows 7 x64, MySQL 5.6.27 (MyISAM) & Workbench 6.3.5 x64.

Tested on OSX Yosemite 10.10.4, MySQL 5.5.27 (MyISAM), Workbench 6.3.5 build 201 CE x64.

转载于:https://my.oschina.net/wanily/blog/599710