問(wèn)題mysqlworkbench7.0之后的版本使用exportdata時(shí)會(huì)遇到這個(gè)錯(cuò)誤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原因我們看錯(cuò)誤報(bào)告顯示這個(gè)變量\’delayed-insert=false\’不被識(shí)別,workbench默認(rèn)配置里會(huì)開(kāi)啟這個(gè)變量并且默認(rèn)值是false。如果我們用不到這個(gè)變量可以更改配置文件,注釋掉這個(gè)變量來(lái)解決123解決步驟
找到配置文件目錄:__installpath__/modules
打開(kāi)python格式的輸出配置文件:wb_admin_export_options.py
找到所在行:\”delayed-insert\”:[\”write insert delayed statements rather than …
在行開(kāi)頭插入#號(hào)注釋改行
保存文件,重啟workbench
配置文件所在位置windowsworkbench的安裝目錄如:c:\\\\programfiles\\\\mysql\\\\mysqlworkbench6.3ce\\\\modules12macapplications->mysqlworkbench.app/contents/resources/plugins.note:在應(yīng)用上右擊選擇showpackagecontents進(jìn)入應(yīng)用目錄12ubuntu/usr/lib/mysql-workbench/modules/wb_admin_export_options.py1