Restoring your back up from wordpress back up plug-in

At the time I wrote the “Back up wordpress using a plug-in” guide, I thought restoring the back up was just as easy as doing an import (Dashboard->Manage->Import->Wordpress) in wordpress. I was wrong. I did the import thing yesterday and I got nothing.

So I studied the back up file that was being sent to my email everyday. It has a file extension of sql which is different from the import file required by wordpress. Wordpress needs a file extention of xml. So in a nutshell, file.sql is different from file.xml so it won’t work. However, I found a way to make it work and let me restore the back ups.

Should I share it with you? (*thinks about it–maybe not! mwahahaha* … *slaps self*)

So basically, I’m going to write a guide about this. I would be happy if you have some knowledge on SQL (Structured query language). If you are going to ask me what’s SQL, my answer would be, database. (as you can see, I can’t even define it..^_^)

Requirements:

  • SQL file from the wordpress database back up
  • Access to your blog database (I’ll be using phpMyAdmin for this guide)
  • wordpress wp-config file

I will provide a brief summary of what this guide will do. This guide will teach you how to import the sql file you got from the wordpress database back up plug-in into your blog database.

Restoring the back up

Step 1: Know your blog database name

You can find this in your wp-config file.

Step 2: Add your database name into your sql file

I am not sure if the plugin author forgot this but if you don’t specify what database to use in SQL, it will return an SQL error. Just add this line on the top of the file.

Important: Use back quotes and not quotes .

Step 3: Import the sql into your database using phpmyadmin

After clicking…

Hopefully, it will import without any problems. After that, you can give yourself a pat in the back ^_^

If there’s something missing or you found some errors while doing the restoration of your database, please leave a comment and I’ll try my best to help you. Thank you.

Related Items:

Best Practices for the Knowledge Society. Knowledge, Learning, Development and Technology for All: Second World Summit on the Knowledge Society, WSKS 2009, ... in Computer and Information Science)
WordPress 2.7 Complete
WordPress 2.7 Cookbook
Blogging All-in-One For Dummies
WordPress 24-Hour Trainer: Watch, Read, and Learn How to Create and Customize WordPress Sites (Book & DVD)
| wordpress import sql plugin | restore wordpress database plugin | how to restore wordpress in cpanel | restore sql database plugin | wordpress sql backup | restoring wordpress from back up | restoring wordpress sql database to cpanel | wordpress plugin import sql | how do i restore my wordpress from backup sent to my email | restore wordpress sql | plugin xml backup for wp | restore wordpress backup | how to restore wordpress from xml | backup wordpress | restore wordpress xml backup | restore wordpress database | restoring wordpress site from backup | restoring wordpress nothing | restoring wordpress from backup | sql long import wordpress
  • Adding plug-ins to wordpress
  • Back up your blog using wordpress admin panel
  • Back up wordpress using a plug-in
  • Is your blog ready for Wordpress 2.3?
  • Wordpress Automatic Upgrade Plug-in upgraded my blog
  • Posted in All on Blogging, Wordpress on Aug 10th, 2007 by Allen Gurrea   

    4 Responses

    1. dexter (72 comments.)
      January 6th, 2008 | 2:31 am

      I tried this and did not work for my site. i have a feeling that my site has been hacked

      Reply

    2. Kay Kastum (1 comments.)
      April 3rd, 2008 | 6:08 pm

      I’ve just installed the new WP2.5. Can’t seem to easily do backup and restore to another wordpress theme. i will try this method now and tell you the result…. :)

      Kay Kastum’s last blog post..Disk Space=Infinity

      Reply

    3. Allen (931 comments.)
      April 5th, 2008 | 10:33 am

      @Kay Kastum – Umm you are trying to change your wordpress theme? I’m afraid this plug-in cannot help you as it only makes a backup of your database. :)

      Reply

    4. April 14th, 2008 | 5:26 pm

      [...] plugins for backing up database, but all of them don’t have the restore system. You have to restore the back up manually. Until I found WP-DBManager [...]

    Leave a reply

     
    | |

    Powered by Yahoo! Answers