Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Database Nearly Full - Help


Recommended Posts



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.

Link to comment
Share on other sites

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.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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.

Link to comment
Share on other sites


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

  • Create New...