Upgrade to 1.3.9h by copying DB tables?

[Picci]

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!

[kobra]

That is not the recommended way to do this

[Vger]

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

[Picci]

OK, thank you for the help.