To increase ‘max_allowed_packet’.
I came across this issue when trying to import 1.6gb sql dump. It took me a couple of hours to figure this out. So here is how I did it…
Go and edit this file:
# nano /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
max_allowed_packet=64M <----- Add this line to 16m, 64m, 128, or 256m
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
After you will need to do mysql restart, then check status by typing in the following command
# mysql service status
You should see below of succesful:
max_allowed_packet | 67108864
Comments are closed