Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2006 - MySQL server has gone away when backing up


ianric

Recommended Posts

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

  • 5 months later...

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

@@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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...