当我试图获取一个大的SQL文件(一个大的INSERT
查询)时,会出现这个错误.
mysql> source file.sql
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: *** NONE ***
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3
Current database: *** NONE ***
表中的任何内容都不会更新.我try 过删除和取消删除表/数据库,以及重新启动MySQL.这些都不能解决问题.
以下是我的最 Big Data 包大小:
+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
以下是文件大小:
$ ls -s file.sql
79512 file.sql
当我try 另一种方法时...
$ ./mysql -u root -p my_db < file.sql
Enter password:
ERROR 2006 (HY000) at line 1: MySQL server has gone away