MySQL:Got a packet bigger than ‘max_allowed_packet’ bytes
admin | Nov 11, 2009 | Comments 0
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
Filed Under: Quick fixes • Technical
About the Author: InstaCarma is a provider of Enterprise Class Solutions for the Hosting Industry

1800 810 6547