CorePart Posted January 14, 2013 Share Posted January 14, 2013 Hi, im in the process of upgrading my customers site from 1.4.8 to 1.5+ What id like to do is only copy over the database categories and products. which specific tables should i pull over? is it even possible? I dread the thought of having to tell my customer they need to redo there full product list and categories. Cheers Link to comment Share on other sites More sharing options...
Dev On Web Posted January 14, 2013 Share Posted January 14, 2013 Hi, The database structure is not the same accross versions ! Don't copy tables. Uses the upgrade module for this. Link to comment Share on other sites More sharing options...
CorePart Posted January 14, 2013 Author Share Posted January 14, 2013 Ah fair enough, I will need to downgrade then upgrade and backup the 1.5+ database. as my theme isn't compatible so its being recoded for the latest updates. Thank you Dev On Web for your hasty reply. Cheers Link to comment Share on other sites More sharing options...
CorePart Posted January 14, 2013 Author Share Posted January 14, 2013 I Have another query, I have manged to get upto 1.5+ with my database but id like to get a fresh start i.e settings etc but again would like to retain products and categories. now that im upto latest version can i just import specific tables? Link to comment Share on other sites More sharing options...
CorePart Posted January 14, 2013 Author Share Posted January 14, 2013 If anyone else has a better way to just import the cats and products please let me know id be very grateful. just started using Prestashop impressed so far with the product. Link to comment Share on other sites More sharing options...
monstercreativestudio Posted January 14, 2013 Share Posted January 14, 2013 i don't have a solution. but upon doing some troubleshooting, my database seems to have an error in it slowing down the shop. HAve a day old db that I would like to import the one sale that happened and couple new customers. So I would appreciate any help on this too Link to comment Share on other sites More sharing options...
CorePart Posted January 15, 2013 Author Share Posted January 15, 2013 Im hoping a Prestashop Admin will reply to this thread, my database has a corruption in it anytime i reload it the website doesnt display but all the products will be in the admin back end. so this is my reason for wanting to know which tables to import as i believe the access table or something is holding wrong data. Link to comment Share on other sites More sharing options...
Sping Posted January 16, 2013 Share Posted January 16, 2013 What about using something like Navicat to import and export parts of your database. I have found upgrade procedure so buggy, something always breaks and the databases are never "clean" when you compare them to a new install. Link to comment Share on other sites More sharing options...
CorePart Posted January 16, 2013 Author Share Posted January 16, 2013 Yeah id have to agree Sping. Going to have to try something to get that data back and contacting prestashop is pretty useless never get a reply. Hoping they check the forums atleast. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts