Title: Extract Posts from a WordPress blog
Last modified: August 5, 2019

---

# Extract Posts from a WordPress blog

 *  [mickey65](https://wordpress.org/support/users/mickey65/)
 * (@mickey65)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/extract-posts-from-a-wordpress-blog/)
 * I have backups for over 200+ WordPress blogs that I have created in the past 
   1 1/2 years.
 * The blogs are no longer installed!
 * After each blog was created and set up, I used a plugin called Duplicator to 
   create a backup.
 * The plugin created a zip backup that contains the database and all WordPress 
   files/folders for the blog.
 * Most of the blogs have plugins that no longer work and prevent the blog from 
   even loading.
 * If I delete anything from the backup zip (plugins or themes), then the backup
   is no longer valid and cannot be used to recreate (restore) the blog.
 * I know the posts are stored in the database in a table called wp-posts.
 * Without reinstalling the blog, is there any way to extract or export the posts
   into text, word or pdf?
 * I have a program that converts XML to Microsoft Word or to a PDF
 * I can also convert word or PDF to text

Viewing 1 replies (of 1 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/extract-posts-from-a-wordpress-blog/#post-11799114)
 * In what format is the database backup? Ideally, you want SQL format, but properly
   constructed XML or CSV will work as well. All of these are really plain text 
   files that you can edit in a text editor. You could extract out the data you 
   are interested in and import such data into the DB through phpMyAdmin.
 * You will likely need the content of the post meta table for complete post data
   to be available. Additionally, if you want taxonomy data to go with the posts,
   there are 4 different taxonomy related tables to import. And if you want comments
   as well, there are two more tables for those.
 * It’ll be useful to export some current DB data in the appropriate format to use
   as a reference in determining the complete structure you need in order to build
   an import file that will be successfully imported.

Viewing 1 replies (of 1 total)

The topic ‘Extract Posts from a WordPress blog’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [6 years, 10 months ago](https://wordpress.org/support/topic/extract-posts-from-a-wordpress-blog/#post-11799114)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics