Updating Data base

[DrByte]

As to transferring selective data from old database to new, the following post should help:

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

[sparktronic]

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.

[DrByte]

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.

[sparktronic]

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.