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??
Results 1 to 6 of 6
-
26 Sep 2006, 06:55 PM #1
Inactive
- Join Date
- Dec 2005
- Location
- NY
- Posts
- 188
- Plugin Contributions
- 0
Upgrading SQL DB from 1.2.7 to 1.3.5
-
26 Sep 2006, 09:12 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
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, 09:22 PM #3
Inactive
- Join Date
- Dec 2005
- Location
- NY
- Posts
- 188
- Plugin Contributions
- 0
Re: Upgrading SQL DB from 1.2.7 to 1.3.5
Just what I needed to hear...thanks again, Doc!
-
27 Sep 2006, 09:51 AM #4
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
1. drop all tables of the 1.3.5 DB
2. import the 1.2.4 DB sql
3. Then run the upgrader in the zc_install files.
??
-
27 Sep 2006, 10:12 AM #5
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, 10:25 AM #6
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
Similar Threads
-
Getting SQL errors since upgrading
By bogyi in forum General QuestionsReplies: 4Last Post: 1 Nov 2010, 09:32 AM -
1064 SQL Syntax error when upgrading database from 1.3.8 to 1.3.9
By pioupioun in forum Upgrading from 1.3.x to 1.3.9Replies: 5Last Post: 23 Aug 2010, 06:26 AM -
Problem upgrading into new sql database
By cpaulson in forum Upgrading from 1.3.x to 1.3.9Replies: 26Last Post: 14 Nov 2009, 06:47 PM -
Will problem upgrading from 1.3.7 to 1.3.8 prevent me upgrading to future version?
By lennypeng in forum Upgrading from 1.3.x to 1.3.9Replies: 3Last Post: 19 Jun 2008, 12:44 AM -
SQL - import when upgrading - HELP!
By cotswold in forum Installing on a Linux/Unix ServerReplies: 11Last Post: 10 Oct 2007, 04:35 AM
Bookmarks