Eli the Computer Guy

Content including Pages and Blog posts are stored in the table NODE_REVISIONS in the main database of your Drupal installation.  Recently my Drupal site had a massive failure and I was able to go into the MySQL database and recover my posts from this table.  It’s not nice and neat, but if you don’t want to rewrite all of your posts it’s a way to get them back.