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

mile23’s picture

mile23
Primary language English
Location Seattle, WA
commented

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

ronan’s picture

ronan commented
Issue summary: View changes
Status: Active » Postponed (maintainer needs more info)

Are you still having issues with this?

jkingsnorth’s picture

jkingsnorth commented
Priority: Critical » Normal
Status: Postponed (maintainer needs more info) » Closed (fixed)

Good advice was offered. There was no further information from the original poster, so I'm going to close off this issue. Please reopen it with further information if it is still a problem =]