目录
目录X
mysql导入ERROR 2013 (HY000) at line 6169: Lost connection to MySQL server during query
AI摘要(BLUF)
问题描述:mysql导入ERROR 2013 (HY000) at line 6169: Lost connection to MySQL server during query
解决办法:
找到您的 MySQL 配置文件(通常位于 C:\ProgramData\MySQL\MySQL Server x.x\my.ini),在 [mysqld] 段增加以下内容:
[mysqld]
max_allowed_packet=512M
net_read_timeout=300
net_write_timeout=300
interactive_timeout=600
wait_timeout=600
……
问题描述:mysql导入ERROR 2013 (HY000) at line 6169: Lost connection to MySQL server during query
解决办法:
找到您的 MySQL 配置文件(通常位于 C:\ProgramData\MySQL\MySQL Server x.x\my.ini),在 [mysqld] 段增加以下内容:
[mysqld] max_allowed_packet = 512M net_read_timeout = 300 net_write_timeout = 300 interactive_timeout = 600 wait_timeout = 600 innodb_log_file_size = 256M
⚠️ 修改后必须 重启 MySQL 服务 才能生效!
重启服务器后再次导入正常