Showing posts with label phpmyadmin Got a packet bigger than max_allowed_packet bytes. Show all posts
Showing posts with label phpmyadmin Got a packet bigger than max_allowed_packet bytes. Show all posts

Friday, May 10, 2013

phpmyadmin error : #1153 - Got a packet bigger than 'max_allowed_packet' bytes

 phpmyadmin- Got a packet bigger than 'max_allowed_packet' bytes

 


Error in phpmyadmin while uploading sql file :

1) Open file my.cnf 
path of the file : /opt/lampp/etc/my.cnf

2) Set value max_allowed_packet=128M under attribute [mysqld] 
    If parameter is not there, add it under attribute [mysqld] .
[mysqld] max_allowed_packet=128M

3) Restart XAMPP.