Title: Retrieve Posts from Database
Last modified: August 20, 2016

---

# Retrieve Posts from Database

 *  [4quad](https://wordpress.org/support/users/4quad/)
 * (@4quad)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/retrieve-posts-from-database/)
 * Hi,
 * How do I retrieve posts from a database? All the files on my server where corrupted
   but my database is fine. I have managed to export the database and install it
   on a localhost installation, the problem lies with the fact that not all my posts
   are there.
 * Where should I look for my posts in the database?
 * Any help will be appreciated.

Viewing 1 replies (of 1 total)

 *  [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * (@apljdi)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/retrieve-posts-from-database/#post-2827877)
 * > 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.

Viewing 1 replies (of 1 total)

The topic ‘Retrieve Posts from Database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/retrieve-posts-from-database/#post-2827877)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics