导入1GO SQL文件=>第23行出现错误2013(HY000):在查询过程中失去与MySQL服务器的连接 [英] Importing 1GO SQL File => ERROR 2013 (HY000) at line 23: Lost connection to MySQL server during query
本文介绍了导入1GO SQL文件=>第23行出现错误2013(HY000):在查询过程中失去与MySQL服务器的连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我必须导入1go的sql数据,为了确保安全,我将max_allowed_packet提升到1100M.
Ive got to import 1go of sql data, i raised up the max_allowed_packet to 1100M to be sure.
所以我用:
我的查询
mysql -u root -p -D mainbase < GeoPC_WO.sql
但是1分钟后,它在此过程中停止了,我得到了这个错误:
But 1 minute later it stops during the process and i get this error :
**ERROR 2013 (HY000) at line 23: Lost connection to MySQL server during query
**Lost connection to MySQL server during query****
推荐答案
可能您有一些大于最大大小的大插入语句.检查您的/etc/mysql/my.cnf文件或任何位置.不记得默认值是什么-但将其设置为如下所示的大值可能会有所帮助.
Possible that you have some large insert statements that are bigger than you max size. Check your /etc/mysql/my.cnf file or wherever it is. Cannot remember what the default is - but setting it to something large like below may help.
这是一个选择
[mysqld]
max_allowed_packet = 16M
也许是另一种方式
[mysqldump]
max_allowed_packet = 16M
这篇关于导入1GO SQL文件=>第23行出现错误2013(HY000):在查询过程中失去与MySQL服务器的连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文