Forums / Upgrading from 1.3.x to 1.3.9 / Upgrade to 1.3.9h by copying DB tables?

Upgrade to 1.3.9h by copying DB tables?

Views: 1,267

Results 1 to 4 of 4
12 Jan 2011, 7:09 AM
#1
picci avatar

picci

Zen Follower

Join Date:
Feb 2006
Posts:
125
Plugin Contributions:
0

Upgrade to 1.3.9h by copying DB tables?

I have a ZC 1.3.7 that I need to update to 1.3.9h.

My ZC 1.3.7 is heavily modded.

I had done a ZC upgrade before where I just copied certain tables to a new install of ZC. The tables I copied were the customers* tables, orders* tables, products* tables, categories* tables and the coupons* tables. This got all my products, customers and their orders in the new install. I then went through the admin to set up the rest of my settings. Then I installed the mods I wanted in the new ZC store to finish the upgrade. The reason I did it this way was because I wanted the new ZC version to be as 'clean' as possible and was worried about upgrading a lot of mods and finding myself in a mess.

In your opinion is that a reasonable method to upgrade for someone who is comfortable with working with the database tables or is it kind of a crazy way to do it?

My main question is - do the tables I noted to be copied have the same structure in 1.3.7 and 1.3.9h? I thought I would just ask first, I will actually do a visual inspection before I go for it.

Thanks for your support!

12 Jan 2011, 7:28 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Upgrade to 1.3.9h by copying DB tables?

That is not the recommended way to do this

Zen-Venom Get Bitten

12 Jan 2011, 5:08 PM
#3
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Upgrade to 1.3.9h by copying DB tables?

  1. You upload 1.3.9h to a test folder and install it, using a new database with new MySQL user name and password.

  2. You take a backup of your 1.3.7 database, ticking the box which says "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT"

  3. You import that into the new database created for the 1.3.9h website. The new tables will be dropped and replaced with the old 1.3.7 tables.

  4. You upload the zc_install folder for 1.3.9h to the root of where you have your 1.3.9h test site, access it, and choose the "Upgrade Database Only" option, which will upgrade known Zen Cart tables to the 1.3.9h level. Your 1.3.7 database is then patched to 1.3.9+ level.

Vger

13 Jan 2011, 9:00 AM
#4
picci avatar

picci

Zen Follower

Join Date:
Feb 2006
Posts:
125
Plugin Contributions:
0

Re: Upgrade to 1.3.9h by copying DB tables?

OK, thank you for the help.