mysql 5.7导入数据报错
报错信息如下:
2006 - MySQL server has gone away
修改my.ini 配置文件中:修改 max_allowed_packet 的大小
max_allowed_packet = 512M
或者进入命令执行:
查看 show VARIABLES like ‘%max_allowed_packet%’;
max_allowed_packet: 536870912字节=512M
修改 max_allowed_packet: set GLOBAL max_allowed_packet = 102410241024