Cs Cart Orders Missing Order Data After Restore

General General Questions
1

I had to get my host to restore the database and 3 days later I have discovered that all orders prior to the database retstore are missing all product data from the order.

http://prntscr.com/bvnkjz

I have previous full database backups of my own, is there anyway I could use these to get some of the order data back in most of the previous orders perhaps?

Thanks

John

2

You should copy data for corresponding orders from the cscart_order_items table. It will restore the ordered products data

3

You should copy data for corresponding orders from the cscart_order_items table. It will restore the ordered products data

Thanks, do you mean, restore an old database to a cloned copy of the store in a sub dir, then copy from there to live store

JOhn

4

Thanks, do you mean, restore an old database to a cloned copy of the store in a sub dir, then copy from there to live store

JOhn

Yes, it should work. Backup only data without schema. Just in case, do not forget to make backup of the live DB