restoring a deleted user account

I have a member that was well established on my site, who inadvertently deleted their profile after some confusion with facebook connect. 

I perform hourly database dumps so I have all of his information. How difficult is it to restore the old account? Do I just need to import the profile table  data or are there more hooks involved?

You can insert into the Profiles table and plug his/her information in (e.g., username, password, salt, etc.).  His/her content would be a whole 'nother mess.

the downside to this is that you can restore a database, would need to be the complete database, however, in accomodating one person, how many others are suffering. its not an easy task, because dolphin is dynamic, you would have to restore to a point in history where all was well, but then you lose everything from that point forward. so if the person deleted the profile on sunday, and you are restoring today, then everything from the point of delete forward would be removed. 

catch22 good luck. 

I ended up extracting their profile data from the backup & inserting it back into the live site. The account fundamentals are back in place, but that doesn't amount to much. At the very least, they are re-linked with their old forum posts but all other content is gone. 

I haven't had much time to completely dig into it, so I'm hoping either of you may have a quick answer here - is all of their uploaded content completely nuked, or just purged from the database? IE do the jpegs still exist on the server. 

While it would be tedious, I don't think it'd be terribly difficult to examine the db backup and write up a query that gets me the data I need. One thing I have going for me is that my site is only slightly active. In a large production environment, I'd quickly tell them to have fun recreating their content :)