watman10 Posted June 1, 2011 Share Posted June 1, 2011 Hi,I am looking to migrate from Prestashop v1.3 to v1.4However, our database is over 3GB in size and is not easily downloaded and re-uploaded.Is anyone aware of how I can strip historical data out of it (Just want to be left with the essentials - Customers, Products, Orders etc)Any help is much appreciated.M Link to comment Share on other sites More sharing options...
Raphaël Malié Posted June 1, 2011 Share Posted June 1, 2011 Hi, you can skip the content of ps_connection and ps_connection_page table for your upgrade. Anyway 3GB is a really huge size, maybe you should use Myisam instead of Innodb. Link to comment Share on other sites More sharing options...
watman10 Posted June 2, 2011 Author Share Posted June 2, 2011 Thanks Raphael,The DB server seems to be on a go slow, i am trying to strip out the historical visitor data for now.any other ideas to speed up site response?M Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now