問題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-triggers\”matchbox_test\”mysqldump:[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