onlydeshpande Posted March 11, 2014 Share Posted March 11, 2014 How to reduce DB size? Which table contents can be dropped to reduce DB size? My SQL database is around 400 MB and bluehost hangs while exporting the DB. hence was looking at possibility if any unimportant data can be deleted. Pls guide. Bit urgent as my bluehost account expires in next few hours. Link to comment Share on other sites More sharing options...
vekia Posted March 11, 2014 Share Posted March 11, 2014 huge db size is usually related to statistics based on prestashop engine. if you don't use it, you can remove all stats tables Link to comment Share on other sites More sharing options...
stratus66 Posted April 9, 2014 Share Posted April 9, 2014 Hello both guys. I am about to start multishop biz and I am concerned about this. Let's say that I close statistics, but I want to have more than 100.000 products what would be the database size? In addition is there a possibility to move existing database to new-other server? Link to comment Share on other sites More sharing options...
NemoPS Posted April 9, 2014 Share Posted April 9, 2014 ps_connections can be usually emptied every now and then, but you'll lose some stats Link to comment Share on other sites More sharing options...
onlydeshpande Posted April 9, 2014 Author Share Posted April 9, 2014 Many thanks Nemo1. Link to comment Share on other sites More sharing options...
Recommended Posts