ianric Posted August 3, 2012 Share Posted August 3, 2012 Hi Everyone Just got this error when I am backing up in admin > tools > backup 2006 - MySQL server has gone away show fields from `table_invoice` [TEP STOP] 2006 - MySQL server has gone away select count(*) as total from sessions where sesskey = '5084d6d79ca801bdb7ef55e4a9a19f9f' [TEP STOP] I have a contrib installed for an auto backup at set intervals and when I first login to my admin section, a backup is automatically done and this works. I've exported the database as SQL from in PHPMyadmin and that runs OK. I think I'm also using this contrib Database_backup_manager_v1.5.1 - Sam (Spooks) 2012/03/20 of original by JanZ Is there anything I can do? I have PHP ver 5.2.17, MySQL 5.0.95. OSC ver 2.2 RC2a Thanks Ian Link to comment Share on other sites More sharing options...
hobievi Posted January 8, 2013 Share Posted January 8, 2013 I was having similar error and couldnt find the right solution on the net, until i found it myself. Solution: emtpy your session and cache tables in your database. Thanks, Yavuz Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 8, 2013 Share Posted January 8, 2013 @@ianric Ian The backup is taking to long and mysql is disconnecting. Clearing down the sessions table will reduce the number of records in the backup. Are there other tables, such as one recording the IP of every visitor, that can be emptied? HTH G Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.