Totally Zenned
- Join Date:
- Feb 2007
- Location:
- South Florida, USA
- Posts:
- 1,375
- Plugin Contributions:
- 0
Merging new customers accounts and transactions into another database
Ajeh and Kobra addressed this issue already, however I do need more information because I am very weak on databases.
I only develop my website offline, when I'm satisfied I upload, but in the meantime new customers have created accounts and entered transactions that I must fulfill.
So, in order to update the site I need to merge the old, online database into the new one that I developed offline.
I think the steps are:
- Check who's online and if nobody, take the site down for maintenance.
- In online database, check certain tables and export to file, checking Add/Drop table.
- Here's the problem. What tables do I need to check to export whole customer info and transactions, maybe also counters?
Also, what is the procedure to merge these tables into the offline database that I will shortly upload?
I really need a detailed description, e.g. the word "merge" has little meaning to me because I don't know how to do it.
Thanks.
[argentiniansupermarket.com