Resolution Mysqlworkbench Export data times wrong: ' Delayed-insert ' =f

Mysqlworkbench Export data times wrong

Problem

mysqlworkbench6.0 version will encounter this error when using Export data. 

Running:/applications/mysqlworkbench.app/contents/macos/mysqldump--defaults-file= "/var/folders/xl/s140j_ D96n5djybp3rvh2nt80000gp/t/tmpn6fxeu/extraparams.cnf "--set-gtid-purged=off--delayed-insert=false--host= 121.40.157.75--protocol=tcp--user=root--port=3306--default-character-set=utf8--skip-triggers "Matchbox_test" Mysqldump: [ERROR] Unknown variable ' delayed-insert=false ' operation failed with ExitCode 713:19:01 Export Of/users/jason /documents/dump20151116.sql have finished with 1 errors123456789

Reason

We see that the error report shows that the variable ' delayed-insert=false ' is not recognized, the variable is opened in the Workbench default configuration and the default value is FALSE. If we do not use this variable can change the configuration file, comment out this variable to solve 123

Resolution Steps

• Locate the configuration file directory:__InstallPath__/modules

• Open the output configuration file in Python format:wb_admin_export_options.py

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

• Insert number at the beginning of line # comment row

• Save file, restart Workbench

Where the configuration file is located windows

Workbench installation directory such as: C:\Program files\mysql\mysql Workbench 6.3 ce\modules12

Mac

Applications, Mysqlworkbench.app/contents/resources/plugins. Note: Right-click on the app to select Show Package contents to enter the app catalog 12

Ubuntu

/usr/lib/mysql-workbench/modules/wb_admin_export_options.py1

Resolve Mysqlworkbench Export Data times error: ' Delayed-insert ' =f