ERROR 2006 (HY000) at line 348: MySQL server has gone away

Written by

When i try to restore a MySQL database, i get following error.

[root@server2 ~]# mysql sok_wp < /var/www/sok_wp.sql
ERROR 2006 (HY000) at line 348: MySQL server has gone away
[root@server2 ~]#

To fix the error, edit file

/etc/my.cnf.d/my.cnf

Add

max_allowed_packet=64M

Restart MySQL

service mysql restart

if using mariadb, run

service mariadb restart

Comments