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.