ERROR 1153 : Got a Packet Bigger Than ‘Max_allowed_packet’ Bytes”

You may have come across this error before while trying to restore mysql databases, it can be easily fixed by increasing max_allowed_packet value. Check the current value first. Get into mysql prompt and enter the following query :
select @@max_allowed_packet;
Then you can increase the value either by adding the variable in my.cnf file or executing the query in mysql prompt :
set global max_allowed_packet = 64*1024*1024; (64 MB, change it as per your needs)
Restart mysql if you are setting the value in my.cnf file. Now check the new value using the same query we used above and try restoring the database.