I have a new wordpress installation + old database, how can I get my old stories (2 posts)

  1. v0idnull
    Posted 3 years ago #

    So I have a mysql dump of an old wordpress installation. This contains plenty of content I would like to keep.

    Now, I don't remember all the plugins I had installed or anything like that, so I may not be able to recoup everything, but surely I can readd the content and possibly fix what's broken.

    Coding is not a problem for me, so if there is a simple API where I can just do SELECT title,content,created_on FROM posts then just add it with a method/function call, I'm cool with that. As long as I can salvage what I've got.


  2. Brian Harris
    Posted 3 years ago #

    Simple solution would be to set up a localhost environment with the WP version of your database dump ....i.e. if you took the dump at say WordPress 2.5 then install that version on your local machine and import the database. (This assumes you know the WP version at the time of dump)

    But before you do that - open up the sql dump in a notepad (I recommend Notepad++) and do a find search for plugins. This will return the section of the dump listing the active plugins at the time. Install them prior to importing the sql tables.

    From then on you can upgrade chronologically updating the database and the plugins - removing those plugins which are no longer compatible as you go along. When you are up to date simply transfer your site to a live staging environment and you are done.

    You can get the relevant WP release from http://wordpress.org/download/release-archive/

    Hope that helps somehow,

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.