Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Location
    The Netherlands, Wierden
    Posts
    430
    Plugin Contributions
    0

    fresh database update, which tables?

    I want to update my shop from 1.2.7 to 1.3.0.1, I also want a clean database.

    So I did a new clean install from ZC, I made my template ready for 1.3x. And now I want to backup most of my previous tables.

    I read a way to do is to backup the database. Remove all tables from the DB. Copy all tables from previous db into new db. And do the install again with only db-upgrade.

    But I have a lot of contributions in the previous installation which I don't use anymore. So I don't want these fields or tables into the new DB.

    Which tables do I need to backup and restore into the new 1.3 db. I need the users with all history order-status. And of course all categories with product.

    Another question: Are there any changes in the (html)email templates or can I use the old email-folder?

  2. #2
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: fresh database update, which tables?

    You have your sequence a little off.

    Nothing better than advice from Ajeh
    See post 4 in the following thread.

    http://www.zen-cart.com/forum/showthread.php?t=32464

  3. #3
    Join Date
    Jul 2004
    Location
    The Netherlands, Wierden
    Posts
    430
    Plugin Contributions
    0

    Default Re: fresh database update, which tables?

    thnx for reply, but i read that thread.
    I read a way to do is to backup the database. Remove all tables from the DB. Copy all tables from previous db into new db. And do the install again with only db-upgrade.
    But that wasnīt the question, I would like a clean install and restore users with their purchases and all categories with products.

  4. #4
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: fresh database update, which tables?

    Let's try this again.

    If you have a backup of the 1.2.7 database then--

    Install 1.3.1 full (save overrides, etc. that are unique to your site first)

    After installation of 1.3.1, delete the database and insert the database from 1.2.7.
    Use zc_install to upgrade the database ONLY.

    That should bring in your customers and products.

    HTH

  5. #5
    Join Date
    Jul 2004
    Location
    The Netherlands, Wierden
    Posts
    430
    Plugin Contributions
    0

    Default Re: fresh database update, which tables?

    i know, i have done that. That works okay, but i have many contribs into my which I donīt use anymore, and I donīt want them into my new database. Therefor I want a clean install and just restore the tables I really use.

 

 

Similar Threads

  1. v153 Which tables do I need to backup
    By su35 in forum General Questions
    Replies: 3
    Last Post: 2 Dec 2014, 02:44 PM
  2. Bulk update of prices needed - which table to update thru back end?
    By one tall man in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 8 Dec 2013, 11:02 PM
  3. Which tables to export?
    By fendy in forum General Questions
    Replies: 3
    Last Post: 10 Sep 2011, 06:16 AM
  4. Create Database, Tables and Drop Database or Tables
    By elwood cordery in forum General Questions
    Replies: 3
    Last Post: 17 Aug 2009, 04:03 PM
  5. Which tables to move for attribute files
    By cshart in forum General Questions
    Replies: 0
    Last Post: 15 Feb 2007, 03:44 AM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR