Member Blog Disappeared

I had a member's blog to disappear.  I don't know how it may have gotten deleted.  I need to see if I can import his blog from a backup; which tables do I need to inspect.  How are blog post comments handled?  Which tables?

Looking in the blog module install sql I see the tables that the blog module creates.  I assume I can import from a backup of those tables using -ignore and it should put the missing blog back in place?

How would you proceed? What about site stats?  I am thinking that the person accidentally hit the delete button and then OKed without realising what they were OKing to since it just says, Are you Sure.  That message will be changed and another alert added, that should be a double bozo checker; "Final Warning. Are you sure you want to delete ALL blog posts?"

What about blog posts views?

This is the plan of action.  We are restoring a backup to a new database.  Once that is done, we will look at exporting the rows in each of the blog tables for the user in question.

Question, what about site stats listing blog posts?  What about blog views?  Anything else?

Seems the comments will be tricky to restore.  The structure for that table is:

CREATE TABLE `[db_prefix]_cmts` (
  `cmt_id` int(11) unsigned NOT NULL auto_increment,
  `cmt_parent_id` int(11) unsigned NOT NULL default '0',
  `cmt_object_id` int(11) unsigned NOT NULL default '0',
  `cmt_author_id` int(11) unsigned NOT NULL default '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint NOT NULL default '0',
  `cmt_rate` int(11) NOT NULL default '0',
  `cmt_rate_count` int(11) NOT NULL default '0',
  `cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `cmt_replies` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Any suggestions?