Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    Nov 2005
    Location
    Rochester, New York
    Posts
    165
    Plugin Contributions
    0

    Default Re: Updating Data base

    I did do the upgrade the way the instructions said. That is my quandry. The only thing I did that I did not see on the instructions. is how to get the data, not the dat structure, into the new data base. I will check the links, but I did not see anything on taking your old dat information and upgrading that. I followed the zc_install upgrade instruvctions for the program though.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Updating Data base

    The entire upgrade process is intended to be driven around upgrading an existing database, not copying selective data from an old database and only moving certain pieces of it forward. This is so that all data is kept in sync.

    However, in limited cases this may be necessary, so the procedure is:
    - backup old database
    - install a fresh v1.3.x site into YET ANOTHER new clean unused database
    - test it
    - restore old database overtop of new database
    - run zc_install process *again* against new database, and upgrade it to latest structure.
    - NOW DO YOUR SELECTIVE BACKUP of just the tables you think you need
    Use this selective backup for porting data forward to your new site which I assume you have installed in another database somewhere else. Or, now do another fresh clean database install and only import the tables you want.
    .

    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.

  3. #3
    Join Date
    Nov 2005
    Location
    Rochester, New York
    Posts
    165
    Plugin Contributions
    0

    Default Re: Updating Data base

    I hear you and appreciate your comments, but I am no genius. I am stumbling through this like many others. I do not understand why I can't take my data from my customer section, product section and anywhere else I have inputted data and insert or update a data base. I did not reprogram any files, nor do I wish to because you guys are the experts and have done a superb job in making this catalog program. I do not think that you are telling me I have to put a whole new catalog up because that is what I did in the first place. I put ver 1.3 in a new folder, then upgraded it according to zc_install procedures. If I do that I would think I would just get the same results. I have seen other threads with a similar problem and no answer so thats why I put up different ones. I ran into snags and was working until I got an answer and some of the problems I solved. I am not looking to put the structure or anything in that section in the new data base, juust the customers, orders and products with their attributes. Can I, or can I not take data already inputed in another data base and insert it into a clean data base. I do not want to belabor this for you, but If I have a new version with the "can't delete bug and its not working, I wanted to try to avoid starting from scratch.

 

 

Similar Threads

  1. data base
    By scooter in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 9 Jul 2012, 06:29 PM
  2. data base question
    By alamo in forum General Questions
    Replies: 2
    Last Post: 15 Feb 2010, 01:11 AM
  3. Can't access my data MySql data base
    By Roon in forum Installing on a Linux/Unix Server
    Replies: 23
    Last Post: 6 Sep 2007, 03:26 PM
  4. data base
    By sparktronic in forum General Questions
    Replies: 6
    Last Post: 1 Jun 2006, 09:55 PM

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