Forum Posts exist, but the users record is gone, how to fix?
 

I just had to migrate my database from one server to another, and there seems to be some kind of problem. I have a user (one that I can find now) that has his account gone, but some of his posts remain.

I've done searches through the database and found 7 threads and 29 posts that have his postuserid and postusername in there, but his user record does not exist.

What can I do to assign all of the things that remain in the database to an existing account? I imagine that if I run the update counters stuff, it will delete the rogue threads instead? I want to give this user back his previous existance, or as much of it as I can find...rep, attachments, profile, posts, threads, pm's, etc...

Whats the best way to go about that?

Are there any queries I can run to determine if there are any other things that are missing accounts?