Issue :

While trying to restore a database through phpmyadmin, following error occurs:

#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

Solution :

This error occurs if the packet size is more than the default value OR the value defined in the my.cnf file.
my.cnf might be blank on a cPanel server by default. You can simply add the variable to it or increase the value if it already exists.

For example,

max_allowed_packet = 2097152


Shares
Contact Us On WhatsApp