MySQL server has gone away
来源:互联网 发布:博世cms40简易编程 编辑:程序博客网 时间:2024/05/17 08:28
MySQL导入sql脚本错误:2006 - MySQL server has gone away
www.111cn.net 编辑:phper 来源:转载
http://www.111cn.net/database/mysql/59244.htm
到如一些小脚本很少报错,但最近导入一个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]加入:
wait_timeout=200000
interactive_timeout = 200000
意思是最大允许数据包300M,等待超时/活动失效时常200000秒,重启MySQL
Shutting down MySQL.... SUCCESS!
Starting MySQL. SUCCESS!
windows下面 \MySQL\MySQL Server 5.0\my.ini 中添加
max_allowed_packet=300M
wait_timeout=200000
interactive_timeout = 200000
wait_timeout=200000
interactive_timeout = 200000
0 0
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- Mysql server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- mysql server has gone away
- MySQL server has gone away
- jQuery
- Bootstrap model的使用及点击外部不消失
- Java的File类中值得注意的细节问题
- 获取联系人
- swift 之structs相关的学习
- MySQL server has gone away
- 自定义ViewPager、HorizontalScrollView、Indicator实现可滑动的头部
- JavaScript
- QQ 聊天机器人小薇 1.0.1 发布!
- elasticsearch class file for java.lang.AutoCloseable not found
- 【杭电oj】2078 - 复习效率(水)
- Struts2学习(七)—类型转化
- 数据的强制转换+乱码问题分析解决
- java框架之springmvc01