MySQL – Got a packet bigger than ‘max_allowed_packet’ bytes error fix

Hi friends,

Today I tried to import one of my live news site database which have long blob data type to my localhost MySQL with phpMyAdmin and get this “Got a packet bigger than ‘max_allowed_packet’ bytes” for the first time in my life. I never get this kind of awkward message before. I googled this and found various fixing method like set max_allowed_packet = 1073741824; from command line or set “max_allowed_packet = 1073741824;” on [mysqld] section in /etc/my.conf and so on. But nothing works for me.

Then I searched my Variables from phpMyAdmin and changed that to Session value / Global value to 1,073,741,824 and bingo it works for me.

Here is a screen-shot of phpMyAdmin Variables

Screenshot of phpMyAdmin
Screenshot of phpMyAdmin

 

Hope this will help you buddies. 🙂 Happy Coding …

(Visited 7 times, 1 visits today)

Leave a comment

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