Mysql导入Sql文件时报Error Code: 2013 - Lost connection to MySQL server during query
来源:互联网 发布:java高并发的解决方案 编辑:程序博客网 时间:2024/06/05 21:59
MySql 有时我们导入sql文件,文件过大,导致Error Code: 2013 - Lost connection to MySQL server during query这种错误
执行以下:
SHOW GLOBAL VARIABLES LIKE '%timeout'; SET GLOBAL net_write_timeout=28800; SET GLOBAL net_read_timeout=100; SET GLOBAL connect_timeout=100; SET GLOBAL long_query_time=100; SET GLOBAL max_allowed_packet=5242880;
2015年3月19号又遇到这个问题。
修改my.ini
max_allowed_packet = 500M
好了
教你们如何找到系统当中的my.ini文件
开始 运行 services.msc 出现服务 找到mysql 点属性 有一个可执行文件的路径,一直往后找,一定会出现my.ini这文件的具体地址
0 0
- Mysql导入Sql文件时报Error Code: 2013 - Lost connection to MySQL server during query
- mysql执行大文件报错:Error Code: 2013. Lost connection to MySQL server during query
- MySQL error 2013 : Lost connection to MySQL server during query
- ERROR 2013 (HY000): Lost connection to MySQL server during query
- sql文件导入大批量数据时,报错:Lost connection to MySQL server during query
- MYSQl导入大文件[Msg] 2013 - Lost connection to MySQL server during query
- MySQL Workbench:Error Code: 2013. Lost connection to MySQL server during query解决办法
- MySQL Workbench出现:Error Code: 2013. Lost connection to MySQL server during query的问题解决
- Lost connection to MySQL server during query
- lost connection to mysql server during query
- mysql运行转储的sql文件导入大批量数据时,报错:Lost connection to MySQL server during query
- MySQL 错误 2013 Lost connection to MySQL server during query
- MySQL升级后:ERROR 2013 (HY000): Lost connection to MySQL server during query
- mysql升级报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
- [Err] 2013 - Lost connection to MySQL server during query
- 2013 lost connection to mysql server during query
- 错误代码: 2013 Lost connection to MySQL server during query
- mysqldump:Error 2013 Lost connection to MySQL server during query ‘table’ at ... rows
- TOJ 1144. Tree Recovery
- YII CListView 分页 另一种写法
- hdu2850Load Balancing 贪心+优先队列
- usaco3.2.4纺车的轮子
- javaWeb中URLEncoder.encode空格问题
- Mysql导入Sql文件时报Error Code: 2013 - Lost connection to MySQL server during query
- 部署在服务器iis上的web项目所有js无法执行的问题
- HDU 1242 rescue and 优先队列入门
- 轻松解读音视频编码
- 注册时验证用户名(可以是普通用户名、手机号和邮箱)的合法规则(easyui)
- 仿函数进阶——组合型仿函数和自定可以使用函数配接器的仿函数
- 集成百度地图,真机和模拟器其中一个编译不通过
- POJ 3684 Priest John's Busiest Day 2-SAT+输出路径
- 俟非殖谂诳匮淮耪耪被鼻股嫉瓶眉