MySQL导入sql脚本错误:2006 - MySQL server has gone away
来源:互联网 发布:vb中跳出for循环 编辑:程序博客网 时间:2024/05/29 03:25
到如一些小脚本很少报错,但最近导入一个25M的SQL脚本,却重复报错:
Error occured at:2015-06-23 11:42:24Line no.:85Error Code: 2006 - MySQL server has gone away
最终找到原因,原来是MySQL导入大批量数据的时候超出了默认允许最大的数据包所以就提示2006 - MySQL server has gone away
于是找到my.cnf,在[mysqld]加入:
max_allowed_packet=300Mwait_timeout=200000interactive_timeout = 200000
意思是最大允许数据包300M,等待超时/活动失效时常200000秒,重启MySQL
0 0
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- 导入SQL导致"MySQL server has gone away"的解决方法
- mysql导入sql问题:server has gone away
- MySQL错误 ERROR 2006 (HY000): MySQL server has gone away
- MySQL server has gone away 错误
- mysql server has gone away 错误
- mysql操作错误server has gone away
- mysql导入数据错误“ERROR 2006 (HY000): MySQL server has gone away”
- mac os #2006 - MySQL server has gone away 错误解决办法
- sql文件导入时报错2006 – MySQL server has gone away
- navicat导入.sql文件出错 2006 - MySQL server has gone away
- sql文件导入时报错2006 – MySQL server has gone away
- 2006 - MySQL server has gone away
- MySQL server has gone away (2006) 排查
- 备案信息实战注意事项
- [图像]Canny检测的Matlab实现(含代码)
- RedHat下安装Python3
- 12864液晶屏调试笔记.
- 注释转换(C语言->C++)
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- myeclipse2013/2015更新ADT-please update ADT to the latest version
- docker使用总结
- 二叉树的三种遍历方法
- Unity3D手游-横版ACT游戏完整源码下载
- Kth Largest Element in an Array LeetCode Java
- sublime text 3支持中文输入法
- Android中的android:layout_width和android:width区别
- Understanding ASP.NET View State