MySQLWorkbench Data Export时报错
mysqldump: [ERROR] unknown variable ‘delayed-insert=FALSE’
原因:无法识别 ‘delayed-insert=FALSE’这个变量。MySQLWorkbench 里默认”delayed-insert”:[“Write INSERT DELAYED statements rather than INSERT statements.”,”FALSE”, “BOOL”, (“5.0.0”, “5.7.0”)],会开启这个变量,并且默认值是”FALSE”,如果我们用不到这个变量,可以去配置文件里把这个变量注释掉来解决。
解决步骤
- 首先找到这个配置文件,Mac在“/Applications/MySQLWorkbench.app/Contents/Resources/plugins”这个目录下(在MySQLWorkbench.app上右击Show Package contents进入contents目录)
- 找到wb_admin_export_options.py文件打开,然后找到”delayed-insert”:[“Write INSERT DELAYED statements rather than INSERT statements.”,”FALSE”, “BOOL”, (“5.0.0”, “5.7.0”)],在开头添加#注释掉这行,保存退出,重启MySQLWorkbench。