Title: Extracting Posts from database
Last modified: August 21, 2016

---

# Extracting Posts from database

 *  [micropirate](https://wordpress.org/support/users/micropirate/)
 * (@micropirate)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/extracting-posts-from-database/)
 * I have a WordPress site that is bloated with 25K posts. 99% is junk. I want to
   create a new site and and extract about 30 posts from the old database and import
   them to the new one. It has been a while since I did this kind of work.
 * I would just delete 99%+ of the old posts and keep the database, but the installation
   has gone bad and it means I have upload the whole the 3.5G backup(not a problem),
   the problem is that even though I have a large high resource VPS, unarchiving
   that backup brings the whole server to a crawl and I get nasty ticket emails 
   about hogging resources. So that is my last resort.
 * Any help would be greatly appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/extracting-posts-from-database/#post-4528627)
 * Can you just load the database on a local install, do the deletes there, and 
   export the remainder?
 *  Thread Starter [micropirate](https://wordpress.org/support/users/micropirate/)
 * (@micropirate)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/extracting-posts-from-database/#post-4528663)
 * Ding! Great Idea! I will give that a shot. Thank you for the suggestion

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Extracting Posts from database’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [posts](https://wordpress.org/support/topic-tag/posts/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [micropirate](https://wordpress.org/support/users/micropirate/)
 * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/extracting-posts-from-database/#post-4528663)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics