导入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数据，为了确保安全，我将max_allowed_pa​​cket提升到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屋！