MySQL server has gone away
When restoring a MySQL database, i get error “MySQL server has gone away”.
1 2 3 |
# mysql -u root -p'serverok123' sok_wp < backup.sql ERROR 2006 (HY000) at line 5095: MySQL server has gone away # |
To fix this, edit MySQL configuration file. Add following line under [mysqld] section.
1 |
max_allowed_packet = 256M |
Restart MySQL
1 |
systemctl restart mysql |
If you use MariaDB
1 |
systemctl restart mariadb |
Related Posts