Lost my db so went to a backup. I'm using the wordpress.org/extend/plugins/wp-db-backup/ plugin.
Restored via mysql without errors. The interesting part is the data seems to all be there but is not showing up. There are no posts published on site and in admin > manage I can see the amount of published and draft numbers but no actual posts to select. Under dashboard I can see all stats for posts and drafts, comments, categories etc etc but clicking on posts/comments leads to nothing. Categories and tags seem to be fine and do show up under manage.
Backup was from 2.6.1 and I'm on 2.6.2 right now.
edit: I should mention that the post data is present in my wp_posts table under post_content. I'm baffled and limited in mysql knowledge.