MySQL导入sql脚本错误:2006 - MySQL server has gone away
到如一些小脚本很少报错,但最近导入一个10 M的SQL脚本,却重复报错:
Error occured at:2014-03-24 11:42:24
Line no.:85
Error Code: 2006 - MySQL server has gone away
最终找到原因,原来是MySQL导入大批量数据的时候超出了默认允许最大的数据包所以就提示2006 - MySQL server has gone away
于是找到my.cnf,在[mysqld]加入:
代码如下 | 复制代码 |
max_allowed_packet=300M wait_timeout=200000 interactive_timeout = 200000 |
意思是最大允许数据包300M,等待超时/活动失效时常200000秒,重启MySQL
代码如下 | 复制代码 |
[root@lizhong 20140323]# /etc/init.d/mysqld restart Shutting down MySQL.... SUCCESS! Starting MySQL. SUCCESS! |
再重新导入,一切正常!
您可能感兴趣的文章:
MySQL导入sql脚本错误:2006 - MySQL server has gone away
Navicat中MySQL server has gone away错误怎么办
mysql提示MySQL server has gone away导入时报错2006错误
mysql 导入数据报2006错误的解决方法
mysql 导入大文件错误解决方法
General error: 2006 MySQL server has gone away
解决ERROR 2006 (HY000) at line XX: MySQL server has gone away问题
mysql报General error 2006 MySQL server has gone away...错误解决方法
MySQL server has gone away问题的解决办法
有关mysql server has gone away报错的原因分析