Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2005
    Location
    NY
    Posts
    188
    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!

  2. #2
    Join Date
    Jan 2004
    Posts
    58,246
    Blog Entries
    3
    Plugin Contributions
    106

    Default 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!
    Donations always welcome: www.zen-cart.com/donate

    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.

  3. #3
    Join Date
    Dec 2005
    Location
    NY
    Posts
    188
    Plugin Contributions
    0

    Default 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!

  4. #4
    Join Date
    May 2006
    Posts
    45
    Plugin Contributions
    0

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

    ??

  5. #5
    Join Date
    May 2006
    Posts
    45
    Plugin Contributions
    0

    Default Re: Upgrading SQL DB from 1.2.7 to 1.3.5

    Nope - that did not work either

  6. #6
    Join Date
    May 2006
    Posts
    45
    Plugin Contributions
    0

    Default 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

  1. Does upgrading to the current 1.3.5 include the recent fixes?
    By Pauls in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 25 Sep 2006, 01:21 PM
  2. upgrading to 1.3.5
    By khopek in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 16 Sep 2006, 01:09 AM
  3. Oops, installed a 1.2.7 Template on a 1.3.5 install
    By Thenotsowyzewun in forum Templates, Stylesheets, Page Layout
    Replies: 7
    Last Post: 13 Sep 2006, 07:34 PM
  4. trouble upgrading db for 1.3.5 from 1.3.0
    By brownrv in forum Upgrading from 1.3.x to 1.3.9
    Replies: 0
    Last Post: 4 Sep 2006, 07:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •