![MySQL(Navicat)运行.sql文件时报错：[Err] - MySQL server has gone away 的解决方法](https://www.dyjz.cc/uploadfile/img/15/166/970339eb03c2abe732aa5d78e61afdc9.jpg)
Message: MySQL server has gone away
原因可能是sql语句过长，超过mysql通信缓存区最大长度；
调整mysql配置文件中max_allowed_packet
编辑mysql.ini
max_allowed_packet=16M
重启mysql
第一句子网 - 唯美句子、句子迷、好句子大全
时间：2019-02-02 09:29:26
Message: MySQL server has gone away
原因可能是sql语句过长，超过mysql通信缓存区最大长度；
调整mysql配置文件中max_allowed_packet
编辑mysql.ini
max_allowed_packet=16M
重启mysql
![[SQL] Query xxx.sql start [ERR] - MySQL server has gone away [ERR]](https://www.dyjz.cc/uploadfile/img/15/552/9e2f4068b38406162e1c9276a150c2c3.jpg)
![[ERR] - MySQL server has gone away](https://www.dyjz.cc/uploadfile/img/15/855/3e0bd95231e198839bf0c3da29e87823.jpg)
