问题mysqlworkbench7.0之后的版本使用exportdata时会遇到这个错误12running:/applications/mysqlworkbench.app/contents/macos/mysqldump--defaults-file=/var/folders/xl/s140j,d96n5djybp3rvh3nt80000gp/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-triggersmatchbox,testmysqldump:[error]unknownvariable'delayed-insert=false'operationfailedwithexitcode713:19:01exportof/users/jason/documents/dump20151116.sqlhasfinishedwith1errors123456789原因我们看错误报告显示这个变量'delayed-insert=false'不被识别,workbench默认配置里会开启这个变量并且默认值是false。如果我们用不到这个变量可以更改配置文件,注释掉这个变量来解决123解决步骤
找到配置文件目录:,,installpath,,/modules
打开python格式的输出配置文件:wb,admin,export,options.py
找到所在行:delayed-insert:[write insert delayed statements rather than ...
在行开头插入#号注释改行
保存文件,重启workbench
配置文件所在位置windowsworkbench的安装目录如:c:\\programfiles\\mysql\\mysqlworkbench6.3ce\\modules12macapplications->mysqlworkbench.app/contents/resources/plugins.note:在应用上右击选择showpackagecontents进入应用目录12ubuntu/usr/lib/mysql-workbench/modules/wb,admin,export,options.py1