在查询过程中丢失了与 MySQL 服务器的连接? [英] Lost connection to MySQL server during query?

问题描述

可能的重复:
在查询过程中失去与 MySQL 服务器的连接

我正在将一些数据从大型 csv 导入 mysql 表.我在将文件导入表的过程中失去了与服务器的连接.

I am importing some data from a large csv to a mysql table. I am losing the connection to the server during the process of importing the file to the table.

出了什么问题?

错误代码为2013:在查询过程中失去与mySql服务器的连接.

The error code is 2013: Lost connection to the mySql server during the query.

我正在 Windows 服务器上从 ubuntu 机器远程运行这些查询.

I am running these queries from a ubuntu machine remotely on a windows server.

推荐答案

我找到的最简单的解决方案是将 MySql 从 MySQL Workbench 降级到 MySQL 1.2.17 版.我浏览了一些 MySQL 论坛，据说 MySQL Workbech 中的超时时间已硬编码为 600，一些建议的更改方法对我不起作用.如果有人在工作台上遇到同样的问题，您也可以尝试降级.

The easiest solution I found to this problem was to downgrade the MySql from MySQL Workbench to MySQL Version 1.2.17. I had browsed some MySQL Forums, where it was said that the timeout time in MySQL Workbech has been hard coded to 600 and some suggested methods to change it didn't work for me. If someone is facing the same problem with workbench you could try downgrading too.

这篇关于在查询过程中丢失了与 MySQL 服务器的连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！