Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Nearly Full - Help


scribe1974

Recommended Posts

Posted

Hello

 

I have a 100MB limit on storage space for each database with my current host and my Oscommerce database has nearly reached it's limit.

 

Does anyone know if it is possible to clean/delete data of a certain age (say three years) from oscommerce to reduce the database size.

 

I'm quite happy with my host in all other respects so I don't realy want to change hosts.

Posted

There's nothing in the admin that will let you do that but you can edit the database itself and remove things. The easiest would be to clear the sessions and whos line tables. Everything else would require mysql commands to remove by dates.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted

Thanks for the reply, I may have to try clearing some tables by hand.

 

Sessions and Whos online, won't make a difference though as they only contain active information, they are two of the smallest tables in the database.

Posted

Sorry. Me being thick, all my session data was in "epdq_sessions" not "sessions" and it was huge, 35MB.

 

Dumping that will do the trick. Thanks you.

Posted

You may already know this, but optimizing the tables (via the SQL "optimize" command) can free up some space as well.

Check out Chad's News.

Archived

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

×
×
  • Create New...