当你要导入一个比较大的mysql数据库的时候,可能会产生这个错误:
mysql> source file.sql ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 2 Current database: *** NONE *** ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 3 Current database: *** NONE ***
这是因为max_allowed_packet设置的太小了,再/etc/my.cnf中,将这个参数设置为64M或者根据实际情况设为更大的值就可以了
max_allowed_packet=64M
mysql文档:
https://dev.mysql.com/doc/refman/5.5/en/replication-features-max-allowed-packet.html