Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / Would Old 1.2.7d DB overwrite New 1.3.5 DB?

Would Old 1.2.7d DB overwrite New 1.3.5 DB?

Locked

Views: 1,673

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
9 Oct 2006, 8:03 AM
#1
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Would Old 1.2.7d DB overwrite New 1.3.5 DB?

When upgrading my site from 1.2.7d to 1.3.5, I did the following:

  1. Fresh install of ZC v1.3.5
  2. Overwrite 1.3.5 DB with 1.2.7d DB
  3. Run ZC v1.3.5 DB upgrade
  4. Install required mods. (some mod. required changes to DB)

All's well and good but then it dawn on me that during the upgrade, my live site has changed with new products and new/amended data. In order to preserve these changes when I switch to the 1.3.5, I have to:

A. Backup 1.2.7d DB,
B. Overwrite 1.3.5 DB with 1.2.7d DB in step A.
C. Run ZC v1.3.5 DB upgrade

Correct me if I have mistaken, when I perform Step B, whatever DB changes made in Step 4 above would be overwritten. So my question is, how can I preserve the most current DB in my live site without overwriting the DB changes made in Step 4 when I bring 1.3.5 live?

Pardon me for the long message, I hope I have provided sufficient info. for any guru out there to enlighten me. TIA.

9 Oct 2006, 3:47 PM
#3
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Re: Would Old 1.2.7d DB overwrite New 1.3.5 DB?

Thank Misty for the link, looking thru' it, I see that it recommends progressive upgrade of the DB. However, DB changes introduces by 1.3.5 compatible mods. aren't installed in the old 1.2.7d version hence progressive DB upgrade wouldn't prevent the lost of those DB changes introduced by these new mods. :(

9 Oct 2006, 3:52 PM
#4
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,612
Plugin Contributions:
0

Re: Would Old 1.2.7d DB overwrite New 1.3.5 DB?

Most database additions for Add On functionality should be outside the realm of the core database schema and should not be affected by an upgrade.

9 Oct 2006, 7:51 PM
#6
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Re: Would Old 1.2.7d DB overwrite New 1.3.5 DB?

Thank you so very much. I can sleep easier now. :thumbsup: