Rootop 服务器运维与web架构

ERROR 2013 (HY000) at line 1490: Lost connection to MySQL server during query

| 暂无评论

       还原大文件sql备份,数据库报错:

ERROR 2013 (HY000) at line 1490: Lost connection to MySQL server during query

解决办法,编辑/etc/my.cnf  修改:

max_allowed_packet = 500M   //默认比较小

保存重启。

ERROR 1153 (08S01) at line 57: Got a packet bigger than ‘max_allowed_packet’  //同样解决办法

原创文章,转载请注明。本文链接地址: https://www.rootop.org/pages/1374.html

作者:Venus

服务器运维与性能优化

发表回复