目錄
目錄X
mysql導(dǎo)入ERROR 2013 (HY000) at line 6169: Lost connection to MySQL server during query
問題描述:mysql導(dǎo)入ERROR 2013 (HY000) at line 6169: Lost connection to MySQL server during query
解決辦法:
找到您的 MySQL 配置文件(通常位于 C:\ProgramData\MySQL\MySQL Server x.x\my.ini
),在 [mysqld]
段增加以下內(nèi)容:
[mysqld] max_allowed_packet = 512M net_read_timeout = 300 net_write_timeout = 300 interactive_timeout = 600 wait_timeout = 600 innodb_log_file_size = 256M
?? 修改后必須 重啟 MySQL 服務(wù) 才能生效!
重啟服務(wù)器后再次導(dǎo)入正常