Restore from backup error

Permalink 1 user found helpful
I get this error when I try to restore from backup:

mysql error: [1153: Got a packet bigger than 'max_allowed_packet' bytes]

History:
Upgraded from 5.4.2.1 to 5.5.2 and for the most part it all went well. I had some issues that I couldn't resolve and tried to restore from backup but that threw the a really bad error and so I reverted the site back to 5.4.2.1 and it came back missing content so I am trying to install the backup and get the error.

the site has only part of the content. I am hoping that by restoring from the backup that the site we be back 100%.

envisage
 
FernandoCordeiro replied on at Permalink Reply
FernandoCordeiro
This error says your database (Or something in it) is bigger than your server allows.

I'd mail the company running the server and ask them to find a way to put the backup there.


Unless you run the server, then you'll probably get a better support at the MySQL Forums (http://forums.mysql.com/ -> And incredibly enough, people are amazingly helpful over there) or something.
envisage replied on at Permalink Best Answer Reply
envisage
Thanks Fernando. That is exactly what is was. Unlike other posting where the resource limits in the php.ini files needed to be increased - this situation was the my.cnf needed the max_allowed_packet limit increased and all is working.

One thing I also did was to create a new database an import and changed the config file to point to the new database - and not use the restore function in the dashboard. Not that you needed to know all that but I thought it would be useful for others having the same issues.