[Err] 2006 - MySQL server has gone away
来源:互联网 发布:c语言缺陷与陷阱怎么样 编辑:程序博客网 时间:2024/04/28 00:39
1、错误描述
[Err] 2006 - MySQL server has gone away
2、错误原因
在将数据库脚本利用MySQL客户端导入时,出现这个错误;结果查明,由于脚本中的insert语句过多,插入数据量过大,导致MySQL客户端和服务器连接断开
3、解决办法
(1)修改MySQL配置文件my.ini
设置max_allowed_packed参数
(2)查看MySQL连接是否超时
(3)查看服务是否中断
1 0
- [Err] 2006 - MySQL server has gone away
- 【MySQL】[Err] [Imp] 2006 - MySQL server has gone away
- 【已解决】[Err] MySQL server has gone away
- MySQL 数据批量恢复时 [Err] 2006 - MySQL server has gone away 错误的解决
- MySQL 数据批量恢复时 [Err] 2006 - MySQL server has gone away 错误的解决
- 通过Navicat for MySQL恢复数据 mysql [Err] 2006 - MySQL server has gone away [Err] INSERT INTO错误
- 2006 - MySQL server has gone away
- MySQL server has gone away (2006) 排查
- #2006 – MySQL server has gone away
- #2006 - MySQL server has gone away
- 2006 - MySQL server has gone away
- 2006 - MySQL server has gone away
- 2006 - MySQL server has gone away
- OperationalError: (2006, '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
- RPM软件包管理
- springmvc学习笔记(九)文件上传
- Jenkins 邮件配置 (使用 Jenkins Email Extension Plugin)
- Genymotion问题集(侧重win10 系统)
- YUM软件管理
- [Err] 2006 - MySQL server has gone away
- java根据ip地址获取详细地域信息
- Bootstrap 4 更新的新功能(全)
- GT随身调 for ios
- 29个你必须知道的Linux命令
- 台湾的旅游资源
- Android最佳性能实践(一)——合理管理内存
- Java永久代去哪儿了
- 【并查集】LA3644 X-Plosives