its happened a couple of times (well every time I have tried to restore a backup) and exactly the same thing happens.
its clearly exporting the data as the content is all there it just messes with it.
when you say drop the table, do you mean empty pcms2_contents completely?
and re the 'cardinality' is that about setting ContentID to be the primary index?