MySQL import got a packet bigger than max_allowed_packet bytes
When i tried to import the MySQL database backup file on phpmyadmin error showed on page
“Error #import #1153 got a packet bigger than 'max_allowed_packet' bytes in phpmyadmin”
The reason is uploading packets receives bigger than max_allowed_packet bytes, So the best solution will be increasing max_allowed_packet size in mysql config. but not on php side,
This query shows you current values for allowed packet.
As we see above current settings allows 1 MB, If like to increase to 16 MB, execute this query,
This can be done in other way too, by editing "my.cnf" which is in /etc/,
Save the file and restart mysql to take effect.
Incase you have installed xampp, restart mysql separately,
after changes can see it values of allowed packet.
You can easily import databases in MySQL.