Missing Order Info

Hi Tim,

I recently migrated our site to new hosting. Everything seems to be working fine but I did notice that some of my archived orders are missing details about the products in the order. This could cause problems with accounting and record keeping. Is there a way to export/import the data base again now to recover those details without overwriting the current data base entirely? Do you know what table I would be missing info from that would cause me to just be missing the products in the order and not the entire order.

thanks!
Wendy Reed
Baby Bloom Photography

Edited by

The order items are located in the ms_cart and ms_cart _archive tables. You might want to reference those 2 tables from the old installation and the new.

If you were to export / import those tables though, it would overwrite the new data in the new database. But if you find missing rows in those tables, you might be able to just export those rows and import into the new database.

Edited by

We have over 20k rows....but since the migration is fairly new I can export the last week of orders to the old data base and then export the combined databases to the new hosting. right?

However, I can seem to figure out how to export just the rows I want to export. I keeps telling me I have a duplicate key error:
Error
MySQL said: Documentation

#1062 - Duplicate entry '376' for key 1

Do you know why it would tell me this?

Thanks! - Wendy

Edited by

I don't know why it would be doing that on the export. If it was on the import, it might be because there is already a row with that ID in the table.

Edited by

OK, thank you. I'll try it again. Have a great day!

Edited by