MySQL server has gone away 错误
来源:互联网 发布:行知实践园 门票 编辑:程序博客网 时间:2024/05/21 06:50
刚才在导入数据库的时候 SQLyog 报错了
Error Code: 2006 - MySQL server has gone away
搜了下,说是max_allowed_packet (MySQL的一个参数)设置的值不够大。
那我改下就行了 嘿嘿
In Windows:
In the MySQL server installation directory,
in my.ini file, add the following line under [mysqld] in SERVER SECTION.
max_allowed_packet = 16M
in Linux:
Copy the my-xxx.cnf file from /usr/share/mysql to /etc as my.cnf
xxx can be small, medium, large, huge ... depending on the requirement.
$ cp /usr/share/mysql/my-xxx.cnf /etc/my.cnf
In the my.cnf file, change the default
max_allowed_packet = 1M
to
max_allowed_packet = 16M
Save the file and restart MySQL server.
- 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
- 数据结构排序算法总结
- hdu 1102 Constructing Roads(Prim最小生成树)
- Java 设计模式 101
- 记录:DeDe CMS v5.5 图片集上传图片出错的解决办法
- NetICE支持的集成开发环境
- MySQL server has gone away 错误
- Java 设计模式 101
- 一个简单的链表类
- Ctype.h中的常用函数
- MySQL --read-only选项
- End-to-End Web Service Tutorial: Mobile Dilbert Application
- Visual Mobile Designer and Web Services in NetBeans IDE 6.0
- linux 的分类和发展【剪辑】
- j2me中的网络连接