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

Hope this will help you buddies. 🙂 Happy Coding …