MYSQL-[Err] 2006 - MySQL server has gone away
MYSQL-[Err] 2006 - MySQL server has gone away原因:mysql插入多行报错,mysql导入sql文件太大。max_allowed_packet:限制mysql服务端接收到的包的大小max_allowed_packet配置的默认值设置太小,将相应值调大之后再次导入便能成功。查看 max_allowed_packet 的值show global variables like 'max_allowed_packet';查询结果修改值,将该值设置成150M(
转载
2022-03-15 14:40:52 ·
403 阅读 ·
0 评论