After the restore us run I get a whole page with an sql error dump, here's a partial error:
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:132:\"MySQL server has gone away\nquery: UPDATE variable SET value = 's:1:\\"0\\";' WHERE name = 'site_offline'\";s:5:\"%file\";s:57:\"/home/wwwarams/public_html/{sitename}/includes/bootstrap.inc\";s:5:\"%line\";i:608;}', 3, '', 'http://{sitename}/admin/content/backup_migrate/restore', '{sitename}/admin/content/backup_migrate/restore', '99.244.234.185', 1327859168) in /home/www/public_html/{sitename}/includes/database.mysqli.inc on line 134
Although the site seems to be working after the restore, however I noticed that some older data has not been recovered.
Any other person had this experience? any solution or recommendation?
Also should we restore from the zip file or mysql file?

Comments

ronan’s picture

ronan commented
Issue summary: View changes
Status: Active » Closed (works as designed)

This can happen when the mysql server is basically overwhelmed by a restore. There may be a sql statement in the file that is too large or it could be that it ran out of memory. You may want to up some of the limits in your my.conf file and see if that helps.