karasulas Posted April 27, 2008 Share Posted April 27, 2008 Hey all, I have two instances of my store on the same webspace with separate databases - one for the public and one for trialling updates. The problem I have is that when I copy the trial site database over to the public one, it replaces the "best viewed products", "best products purchased" report and any order history changes. How do I retain these items when I replace the database? Which database tables should I not be overwriting? Thanks! Alexander Karasulas Link to comment Share on other sites More sharing options...
karasulas Posted April 30, 2008 Author Share Posted April 30, 2008 (bump) Link to comment Share on other sites More sharing options...
dmnalven Posted April 30, 2008 Share Posted April 30, 2008 How do I retain these items when I replace the database? Which database tables should I not be overwriting? You've answered your own question. As to which tables you wish to save, only you can judge. For starters, I would suggest that the question should be, "which tables need to be updated," rather than a blanket restore. Many of the tables should not be touched, and as they are indexed and cross-referenced, this is a relational database after all, unpredictable results are almost guaranteed if you begin to pick and choose tables without a clear understanding of how they are interrelated. For ALL problems, please review this link first -> osCommerce Knowledge Base Link to comment Share on other sites More sharing options...
karasulas Posted April 30, 2008 Author Share Posted April 30, 2008 You've answered your own question. As to which tables you wish to save, only you can judge. For starters, I would suggest that the question should be, "which tables need to be updated," rather than a blanket restore. Many of the tables should not be touched, and as they are indexed and cross-referenced, this is a relational database after all, unpredictable results are almost guaranteed if you begin to pick and choose tables without a clear understanding of how they are interrelated. Thanks for the reply. I know theoretically what I want to change (pretty much all of which lies under the heading "catalog" in admin), but I don't understand in which tables the information lies, and fear the "unpredictable results" you speak of. Is there a knowledge database anywhere that can give me some insight into what the different tables in my databases do? Link to comment Share on other sites More sharing options...
dmnalven Posted April 30, 2008 Share Posted April 30, 2008 There is some information at my signature link below, and there is a documentation pdf that I have, yet have have been unable to find again. If you do find it, please post back with the link. You need to become a little familiar with database structure, if not already, then spend some time simply reviewing the tables and their contents. It is quite straightforward, with the odd ignorant stare every now and then that may need a little research. For ALL problems, please review this link first -> osCommerce Knowledge Base Link to comment Share on other sites More sharing options...
karasulas Posted April 30, 2008 Author Share Posted April 30, 2008 There is some information at my signature link below, and there is a documentation pdf that I have, yet have have been unable to find again. If you do find it, please post back with the link. You need to become a little familiar with database structure, if not already, then spend some time simply reviewing the tables and their contents. It is quite straightforward, with the odd ignorant stare every now and then that may need a little research. After a short while of browsing around the database I started to understand it a bit more, and I'm sure I'll continue to do so. I guess I just needed you to tell me to look at it! Thanks again. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.