Something went seriously wrong here. Is there a chance you can repeat the process on behalf of your client? Try to use Duplicator plugin it really helps with migrations.
Or do a manual mysql dump on old hosting and import the database yourself.
This definitely went wrong during the database migration.