Jump to content

Data Migration

Recommended Posts

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 post
Share on other sites

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.

Edited by keat
Link to post
Share on other sites

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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...