scribe1974 Posted July 14, 2010 Posted July 14, 2010 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.
Jack_mcs Posted July 14, 2010 Posted July 14, 2010 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
scribe1974 Posted July 14, 2010 Author Posted July 14, 2010 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.
scribe1974 Posted July 14, 2010 Author Posted July 14, 2010 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.
chadcloman Posted July 15, 2010 Posted July 15, 2010 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.