Mat_D1245 Posted July 14, 2016 Share Posted July 14, 2016 Hi Presta community, fed up from all sorts of problems with my 1.6.0.14, I rebuilt my shop on a fresh new 1.6.1.5. Now that I am almost done, I'd like to move the data from to the other. I'd like to do it using phpMyAdmin, my plan is to "copy/paste" the needed databases from one presta to the other. I do have a few questions about it: - Are there any things I should be aware of? - Like tables that are not built the same way? - Is there some kind of a listing of all the tables I need to move to keep my products/orders/clients? As for the pictures, i'll just copy/paste the image folder. Do I forget/miss something? Thanks for any infos! Link to comment Share on other sites More sharing options...
musicmaster Posted July 14, 2016 Share Posted July 14, 2016 Almost every Prestashop version has a slightly different database structure. The transition between 1.6.0 and 1.6.1 is particularly troublesome. You can see the transitions under the install directory in install\upgrade\sql. Every file there indicates the steps needed to transform one version into the next. My advise is to upgrade your old version with the automatic upgrade and then to transfer the tables. Even if the upgrade of the files goes wrong the upgrade of the database goes usually ok. If you want you can use my tool copy_shopdata for the transfer of the tables: https://www.prestashop.com/forums/topic/445453-copy-shopdata-script-for-copying-shop-content-for-upgrade/ 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