Support » Installing WordPress » I have a new wordpress installation old database, how can I get my old stories

  • 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.


Viewing 1 replies (of 1 total)
  • 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

    Hope that helps somehow,

Viewing 1 replies (of 1 total)
  • The topic ‘I have a new wordpress installation old database, how can I get my old stories’ is closed to new replies.