Support » Fixing WordPress » Recovering old SQL dump

  • Hello Everyone,
    I’ve been using WordPress for about 3 years. In the Summer 07 my server crashed and the only thing I manged to recover was an SQL dump of the database (the way that your e-mailed backups used to be sent) – the problem with this is the new version of wordpress doesn’t support restoring this type of file. I have over 2 years of blogging in this backup that I would love to restore but I don’t know how to do it. Is there some way that I can convert a .sql file to an xml file? I tried using the backup/restore plugin to no avail. Any help is GREATLY appreciated!

    Thank you,
    Ryan Kenward

Viewing 11 replies - 1 through 11 (of 11 total)
  • What do you mean the present version doesn’t support backing up from a .sql file?

    That always works.

    When I go to the import section in my admin panel I can only import wordpress entries from an XML file. Apparently it doesn’t send a .sql file backup anymore

    Restoring_Your_Database_From_Backup has instructions to restore a backup but I’m left wondering about the fact you have a backup from 2007, but a blog you have been running since 2007.

    Do you wish to ‘merge’ that backup into your currently running blog, meaning you want all the posts from your backup plus all the posts you’ve made since 2007?

    When I go to the import section in my admin panel

    Which means you didn’t even bother to take a look (not to mention: to READ) the documentation offered as a solution.

    @ MichaelH — Yes! I am trying to merge 2005-2007 into the 2007-present. It crashed and I could never figure out how to get it back.

    Also I use NameSecure hosting, I only have 1 sql database – and no phpMyAdmin… I know they suck but I bought the domain before godaddy became wildly popular.

    Domain registrar and domain hosting are two different things and you don’t necessarily have to have both with the same company.
    Get a decent host.

    I’m guessing you will want to follow some of the suggestions in the Restoring_Your_Database_From_Backup post that relate to using something like phpMyAdmin.

    As a person who is really new to SQL, and has enough knowledge to be dangerous, I find that phpMyAdmin has been essential to backing up and restoring my WordPress databases. I currently manage three different blogs from the same database, and it lets me back the all up with one process.

    If you have a dump of the DB, you may be able to update from that, but be careful!!! If you are trying to merge the data, you will need to make sure you add the contents of the old dump is such a way that you do not delete the current content when it runs into identical post ID numbers.

    thanks moshu…

    Moderator Samuel Wood (Otto)

    (@otto42) Admin

    What I would do:
    1. Install a copy of XAMPP or your own favorite WAMP/LAMP stack on your home machine. This will have everything you need to run a local copy of WordPress.
    2. Import the SQL Dump into your MySQL on that machine.
    3. Put a brand new copy of WordPress onto that stack, and run it as if you were upgrading. This will upgrade the old database to a new one.
    4. Export from the local copy, Import on your real site.

    It’s always handy to have your own machine capable of running a web site locally.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Recovering old SQL dump’ is closed to new replies.