Upgrading SQL DB from 1.2.7 to 1.3.5

26 Sep 2006, 5:55 PM

#1

Inactive

Join Date:: Dec 2005
Location:: NY
Posts:: 162
Plugin Contributions:: 0

Upgrading SQL DB from 1.2.7 to 1.3.5

I've backed up my 1.2.7 SQL DB and now want to import into my 1.3.5 install. I've seen a couple of posts stating that you should drop all tables from the new 1.3.5 install, then bring in your old (existing) DB from 1.2.x.

But wouldn't dropping all tables in the 1.3.5 install remove any new tables that are not in 1.2.x (like ezpages??...I'm assuming new tables have been created in 1.3.5)

Do you drop tables in 1.3.5 before importing 1.2.x, or not drop and just overwrite all tables that exist, keeping any new tables created in 1.3.5??

Custom Golf Clubs - A ZenCart Site!
Get fitted online for a better game!

26 Sep 2006, 8:12 PM

#2

drbyte

Sensei

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

Re: Upgrading SQL DB from 1.2.7 to 1.3.5

The upgrader will build all the new tables, so you need to drop them first.

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

26 Sep 2006, 8:22 PM

#3

tcustomgolf

Inactive

Join Date:: Dec 2005
Location:: NY
Posts:: 162
Plugin Contributions:: 0

Re: Upgrading SQL DB from 1.2.7 to 1.3.5

Just what I needed to hear...thanks again, Doc!

Custom Golf Clubs - A ZenCart Site!
Get fitted online for a better game!

27 Sep 2006, 8:51 AM

#4

livesol

New Zenner

Join Date:: May 2006
Posts:: 43
Plugin Contributions:: 0

Re: Upgrading SQL DB from 1.2.7 to 1.3.5

OK - having a few issues here.

I am attempting an upgrade from 1.2.4 - to 1.3.5

And I am having issues with the DB not pathcing iteslf correctly.

I have a fresh install of 1.3.5 running in a different folder on the server.

So, I should

drop all tables of the 1.3.5 DB
import the 1.2.4 DB sql
Then run the upgrader in the zc_install files.

??

27 Sep 2006, 9:12 AM

#5

livesol

New Zenner

Join Date:: May 2006
Posts:: 43
Plugin Contributions:: 0

Re: Upgrading SQL DB from 1.2.7 to 1.3.5

Nope - that did not work either

27 Sep 2006, 9:25 AM

#6

livesol

New Zenner

Join Date:: May 2006
Posts:: 43
Plugin Contributions:: 0

Re: Upgrading SQL DB from 1.2.7 to 1.3.5

oops - doh - and other such "I am a dumbass" comments

I had made a mistake in the Admin configure files - the admin configure was looking at the old DB - sorted now :blush: