ERROR 2013 (HY000): Lost connection to MySQL server during query
ERROR 2006 (HY000): MySQL server has gone away
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
匯出檔使用 INSERT INTO ... VALUES (...),(...),... 多行合併語法(--extended-insert 預設開啟),單條 SQL 過大導致:
max_allowed_packet。wait_timeout 斷線。匯出時加入 --skip-extended-insert,每行產生獨立 INSERT:
mysqldump -u root -p --skip-extended-insert dbname > dump.sql
匯入即可正常完成。
測試版本:mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64)。
max_allowed_packet(如 64M/128M)並重啟 MySQL。source 指令分批匯入,或程式碼分批執行。