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.

10 thoughts on “Restoring your back up from wordpress back up plug-in

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

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

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

  4. […] 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 […]

  5. WordPress is the best blogging platform ever. It is much better than Typepad and blogspot.;..

  6. i host 5 of my blogs on Blogspot and it is really good for beginners. but if you want something with more features, nothing beats wordpress*,~

  7. Stephan Stiern says:

    I actually got to this website by doing a search for movies to see Online. Can you make an article on the best movies to view online thx

  8. Great post. I was checking constantly this blog and I’m impressed! Extremely helpful information particularly the last part 🙂 I care for such information much. I was looking for this particular information for a long time. Thank you and good luck.

  9. That it was wonderful to study through your article. I personally enjoyed the little while which i used looking at it and wanted to leave a comment to state that….Regards

  10. Thanks for this, I’ll try to follow the steps restoring my backup files in my new blog. 🙂

Leave a Reply