FlyingMonkey Posted July 14, 2004 Share Posted July 14, 2004 Hi, I am trying to merge my store into an empty store (with more built in features and more tables). Empty Store = no product, customer, or order info. but it has existing tables with possibly more columns in some of the tables, plus more tables than the current store. is there a way to just merge two sql databases together? OR do i just need to manually merge each table? If so, I was wondering which tables need to be backed up, for just the products and the customers? and if there are any other essential tables that need to be backed up? thanks in advance. Otherwise... I guess the long way would work.... So far I have: Products: products products_attributes products_attributes_download products_description products_notification products_options products_options_values products_options_values_to_product_options reviews reviews_description Customers: address_book address_format customers customers_basket customers_basket_attributes customers_info Orders: orders orders_products orders_products_attribute orders_products_download orders_status orders_status_history orders_total thanks again. Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Acheron Posted July 14, 2004 Share Posted July 14, 2004 You could just do a data dump only of your entire DB and import it into the new DB. Assuming it was modded properly, you wouldn't overwrite anything of importance (and really shouldn't overwrite anything at all). The "extra" fields (if any) would be empty of course, but they will be no matter how you import. Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2004 Share Posted July 14, 2004 the customer orders would not do you any good unless you had the items they have ordered with the came category/product numbers in there. Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 14, 2004 Author Share Posted July 14, 2004 the customer orders would not do you any good unless you had the items they have ordered with the came category/product numbers in there. if i do what acheron was saying, wouldn't that create the same category and product numbers? Acheron: is "importing" the samething as taking the backup of the current database and puting it into the new database by using "Run SQL query/queries on database" on that file? Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Acheron Posted July 14, 2004 Share Posted July 14, 2004 It is. :) When you dump the original DB in phpMyAdmin it will ask if you want to dump Data, Structure, or both. Select Data and dump, then run the file on the new DB (or cut and paste the instructions, same thing) as you mentioned above. :) Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 14, 2004 Author Share Posted July 14, 2004 It is. :) When you dump the original DB in phpMyAdmin it will ask if you want to dump Data, Structure, or both. Select Data and dump, then run the file on the new DB (or cut and paste the instructions, same thing) as you mentioned above. :) ahh, thanks! Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Karole Posted July 22, 2004 Share Posted July 22, 2004 Did this work? And are you trying to do this with a very old version of Oscommerce? or a relatively new version to new version. I have client with whom I would love to have upgraded to the newest version of os, but she is running a very old version. Thanks in advance.... Karole Thanks, Karole Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 22, 2004 Author Share Posted July 22, 2004 Did this work? And are you trying to do this with a very old version of Oscommerce? or a relatively new version to new version. I have client with whom I would love to have upgraded to the newest version of os, but she is running a very old version. Thanks in advance.... Karole it would be ms2 to ms2, when i get a chance to do it. i believe the ms1 database wouldn't line up perfectly... maybe a senior member would know. =) Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.