mysql 中导入数据库时提示 MySQL server has gone away
来源:互联网 发布:手机淘宝4.2.2安卓版 编辑:程序博客网 时间:2024/05/22 14:40
问题:在使用 Navicat for MySQL 导数据的时候,提示 MySQL server has gone away 异常;
原因:MySQL 导入大批量数据的时候超出了默认允许最大的数据包,或者超出等待的最长时间,或者超出通信缓冲区的最大长度;
解决方法:Windows 环境下在 MySql 文件目录下找到 My.ini 文件,记事本打开,添加如下代码
wait_timeout=2880000 interactive_timeout =2880000 max_allowed_packet=10M
0 0
- mysql 中导入数据库时提示 MySQL server has gone away
- phpmyadmin 导入数据库出现 “MySQL server has gone away”
- PHPMYADMIN 导入数据库的时候 MySQL server has gone away
- mysql中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-1164
- 杭电1671——Phone List(字典树的应用)
- week3——归并排序
- Codeforces 624B Making a String 【水题】
- 项目技术总结三之分布与集群的区别
- mysql 中导入数据库时提示 MySQL server has gone away
- ubuntu10.04貌似安装不了最新版本的chrome
- 07、字体
- 必过的节日
- 避免僵尸进程
- 对于hadoop生态圈的理解
- Codeforces Round #338 (Div. 2) B. Longtail Hedgehog
- POJ 1466 Girls and Boys(二分图最大独立集)
- Android中四种对话框案例