Copy Customer from one Site to Another

[DrByte]

Just because you "successfully imported" a set of SQL statements doesn't mean that the data itself is good and properly matches the new database's proper structure.

As I said, YOU MUST UPGRADE THE OLD DATABASE FIRST before exporting any data that you want to import to another database of a newer version level.
AND you must make sure you actually select all the related records from all the inter-related normalized database tables, otherwise you will have partial data and things will be out of sync and produce unexpected results, even fatal and/or unexplainable errors both on storefront and admin.

If you're gonna blindly move things between databases, at least make sure you're working with apples on both sides, not apples on one and oranges on the other.

[osaeed]

Both apples and oranges do go together in a fruit salad though :)