keat Posted November 15, 2019 Share Posted November 15, 2019 Back full circle and now at the point where I mirror the database on our main site and set to work on the 2020 price changes. This takes me about 3 weeks to complete. The way I work this, I have an identical mirror of the web site on another domain, I make all my price changes on the mirror, then on the 1st of January, I copy the following tables from one database to the other. Category, Category_index, Image_index, Inventory, Option assign, group & value. I've totally missed that Al updated our main site about 6 weeks ago, I never considered the mirror. As I'm now so close to starting work on the price changes, I don't want the added complication of updating the mirrored site. The mirror is on 6.1.8, the main site on 6.2.6 Are there any fundemental database changes on 6.2.6 which could stop this process from working ??? Link to comment Share on other sites More sharing options...
Noodleman Posted November 15, 2019 Share Posted November 15, 2019 just upgrade the 6.1.8 store and then merge Link to comment Share on other sites More sharing options...
keat Posted November 15, 2019 Author Share Posted November 15, 2019 I thought there were problems with the upgrade process, and it had to be done manually. ? Further to this, if i did update automatically, the mirror would be in 6.2.8. I'm happy to leave the mirror on 6.1.8 as long as none of those tables have changed. Link to comment Share on other sites More sharing options...
keat Posted November 15, 2019 Author Share Posted November 15, 2019 A rather drastic way to do this, but I copied the entire public_html folder from my live site to my mirror. Took ages. My mirrored site has 6.2.6 files with a 6.1.8 database Still not sure if the database on 6.2.6 differs from 6.1.8 though. I guess time will tell. Link to comment Share on other sites More sharing options...
bsmither Posted November 15, 2019 Share Posted November 15, 2019 Find the /setup/ folder of CC626. In that folder, find /db/upgrade/. Look for any file numbered greater than 6.1.8.sql. The database statements in any such file will be the differences between CC618 and CC626. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.