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

Started by stenrique on 9 Oct 2006, 8:03 AM · Views: 1,681

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,732
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.

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

9 Oct 2006, 7:17 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

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

I posted some more thoughts here (about taking notes), which may be related:
http://www.zen-cart.com/forum/showthread.php?p=274515&highlight=upgrade#post274515

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

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: