MySQL:Got a packet bigger than ‘max_allowed_packet’ bytes

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 fixesTechnical

Tags:

About the Author: InstaCarma is a provider of Enterprise Class Solutions for the Hosting Industry

RSSComments (0)

Trackback URL

Leave a Reply

Get Adobe Flash playerPlugin by wpburn.com wordpress themes
InstaCarma provides outsourced web hosting technical support, helpdesk management, datacenter automation, cloud service management. Sales - 1800 810 6547 - visit www.instacarma.com