cancel
Showing results for 
Search instead for 
Did you mean: 

Import/Export Customer & Sales VIA SQL WITHOUT oveerwriting existing data

Import/Export Customer & Sales VIA SQL WITHOUT oveerwriting existing data

Hello Magento World,

 

I have successfully exported from an old magento database all the mg_sales & mg_customer fields to transfer customers and orders over to my new database which has been running for a week and has had a few orders which I don't want to lose. Most of the Data is already in the new database but the new orders are not.

 

When I imported these tables (from old database to new) they completely overwritten the existing data thus overwriting the new orders.

 

I had to restore the database back but really need these orders moving over

 

Any help would be appreciated, I am unfamiliar with SQL so please go gentle.

 

Both sites running Magento CE 1.9.2.4

 

Chris.