[摘要]因工作需要，需要导入一个200M左右的sql到user库执行命令mysql> use user
Database changed
mysql> source /tmp/user.sql导... 因工作需要，需要导入一个200M左右的sql到user库执行命令 mysql> use user
Database changed
mysql> source /tmp/user.sql 导入的过程中出现MySQL server has gone away错误，数据导入失败。 错误信息如下： ERROR 2006 (HY000): MySQL server has gone awayERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 11Current database: userERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 12Current database: userERROR 2006 (HY000): MySQL server has gone awayERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 13Current database: user 开始以为是超时导致，因此调大了 connect_timeout 和 wait_timeout 的值。 重新执行后问题依旧。
解决方法： 查看资料，发现了 max_allowed_packet 参数，
官方解释是适当增大 max_allowed_packet 参数可以使client端到server端传递大数据时，系统能够分配更多的扩展内存来处理。 查看mysql max_allowed_packet的值 mysql> show global variables like 'max_allowed_packet';
+--------------------+---------+ |
关键词： mysql导入大大局部数据出现MySQL server has gone away的处理办法