mysql提示MySQL server has gone away导入时报错2006错误
今天导入sql总是提示错误
代码如下:
ERROR 2013 (HY000): Lost connection to MySQL server during query
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server
解决办法一
用mysqldump导出 加上参数--skip-extended-insert
解决办法二
如果还是无法解决我们可以参照下面来看看
找到你的mysql目录下的my.ini配置文件,加入以下代码:
max_allowed_packet=500M
wait_timeout=288000
interactive_timeout = 288000
自己看情况更改数值,我直接改很大,最后记得重启你的mysql服务
这样的话就能很好的解决MySQL server has gone away问题了。其实就是一个数据太大导致了,方法二解决也可以
您可能感兴趣的文章:
mysql提示MySQL server has gone away导入时报错2006错误
Navicat中MySQL server has gone away错误怎么办
mysql 导入数据报2006错误的解决方法
MySQL导入sql脚本错误:2006 - MySQL server has gone away
General error: 2006 MySQL server has gone away
有关mysql server has gone away报错的原因分析
MySQL导入数据库时报错,MySQL server has go away
mysql 导入大文件错误解决方法
解决ERROR 2006 (HY000) at line XX: MySQL server has gone away问题
mysql server has gone away报错原因的分析