mysql server has gone away

报错信息：导入mysql文件入库的时候一直报错mysql server has gone away

报错原因：mysql文件太大了

解决方法：修改max_allowed_packet

查看max_allowed_packet值：show variables like ‘max_allowed_packet’;

修改max_allowed_packet值：set global max_allowed_packet = 设置成你的SQL文件大小（单位为字节）;