Posted by kitling55 on June 11, 2012 at 6:35pm
2 followers
Jump to:
| Project: | Backup and Migrate |
| Version: | 7.x-2.3 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
when trying to restore the database from old backup, the restore failed in the middle with the following error:
PDOException: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes
similar error occur before I tried to restore from an old backup and was the reason I tried to restore.
The site is broken as a result. Any help is appreciated.
Comments
#1
This is a universally problematic error for Drupal sites. You need to do any or all of the following: a) Don't save watchdog tables to your backups, b) don't save cache tables to your backups, and, most importantly, c) reconfigure your MySQL server to allow more packets: http://drupal.org/node/1291756
I had this a lot when I was using Pagodabox, which doesn't let you configure max_allowed_packets. I had to spin up a local development site, restore to that from the B&M backup file, create a SQL dump, re-install Drupal on the hosted site, tunnel back to its DB with a mysql client, and restore that way.
(Needless to say: not using Pagodabox at the moment.)