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