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%.
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%.
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.
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.
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.