Extract Posts from a WordPress blog

  • mickey65

    (@mickey65)


    6 years, 9 months ago

    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

    (@bcworkz)

    6 years, 9 months ago

    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.