MySQL import got a packet bigger than max_allowed_packet bytes

MySQL import got a packet bigger than max_allowed_packet bytes
#1153 – Got a packet bigger than ‘max_allowed_packet bytes

MySQL import got a packet bigger than max_allowed_packet bytes

Step 1:- Open this file my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

max_allowed_packet = 128M (Add this line)

Restart mysql

  • sudo /etc/init.d/mysqld restart

Leave a Reply

Your email address will not be published. Required fields are marked *