Retrieve Posts from Database

All the files on my server where corrupted but my database is fine.

How do you know that?

… the problem lies with the fact that not all my posts are there.

I assume you mean they are not all showing up on the front and/or backend of the site, since you are asking about where they are in the database.

Where should I look for my posts in the database?

All of your posts should be in the wp_posts table where the post_type column is ‘post’– WordPress pages are ‘page’. Custom post types will have another value in that column. The main post body is in the post_content column. Some additional information is in wp_postmeta.