scribe1974 Posted July 14, 2010 Share 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. Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 14, 2010 Share 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. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
scribe1974 Posted July 14, 2010 Author Share 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. Link to comment Share on other sites More sharing options...
scribe1974 Posted July 14, 2010 Author Share 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. Link to comment Share on other sites More sharing options...
chadcloman Posted July 15, 2010 Share 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. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.