Extracting Posts from database (3 posts)

  1. micropirate
    Posted 2 years ago #

    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.

  2. vtxyzzy
    Posted 2 years ago #

    Can you just load the database on a local install, do the deletes there, and export the remainder?

  3. micropirate
    Posted 2 years ago #

    Ding! Great Idea! I will give that a shot. Thank you for the suggestion

Topic Closed

This topic has been closed to new replies.

About this Topic