Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

merge two sql databases?


FlyingMonkey

Recommended Posts

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

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

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

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...