用sql文件导入数据,执行时出现错误: 错误代码: 2013 - Lost connection to MySQL server during query 原因:有时候大的插入和更新会受max_all
用sql文件导入数据,执行时出现错误:
错误代码: 2013 - Lost connection to MySQL server during query
原因:有时候大的插入和更新会受max_allowed_packet 参数限制,导致写入或者更新失败。
解决方法:
修改max_allowed_packet值,默认为1M
max_allowed_packet = 100M