WordPress.org

Ready to get started?Download WordPress

Forums

Recovering old SQL dump (12 posts)

  1. ryankenward
    Member
    Posted 5 years ago #

    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

  2. moshu
    Member
    Posted 5 years ago #

    What do you mean the present version doesn't support backing up from a .sql file?

    Restoring_Your_Database_From_Backup
    That always works.

  3. ryankenward
    Member
    Posted 5 years ago #

    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

  4. MichaelH
    Member
    Posted 5 years ago #

    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?

  5. moshu
    Member
    Posted 5 years ago #

    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.

  6. ryankenward
    Member
    Posted 5 years ago #

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

  7. moshu
    Member
    Posted 5 years ago #

  8. ryankenward
    Member
    Posted 5 years ago #

    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.

  9. moshu
    Member
    Posted 5 years ago #

    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.

  10. tdavislaserapp
    Member
    Posted 5 years ago #

    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.

  11. ryankenward
    Member
    Posted 5 years ago #

    thanks moshu...

  12. Samuel Wood (Otto)
    Tech Ninja
    Posted 5 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic