Restoring your back up from wordpress back up plug-in

Table of contents for Back Up Your Blog
  1. Back up your blog often
  2. How to back up your blog – Introduction
  3. Back up your blog through Cpanel
  4. Back up your blog using wordpress admin panel
  5. Backing up your blogger blog
  6. Back up wordpress using a plug-in
  7. 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.

Previous in series
| wordpress xml backup | restore wordpress SQL | wordpress sql import plugin | wordpress sql import | wordpress sql | wordpress sql restore plugin | wordpress database backup | sql import wp plugin | restoring wordpress backup | wordpress plugin import sql | restored an sql in a wordpress site | restore wordpress from sql | phpmyadmin xml wordpress import | import sql wordpress plugin | import sql file wordpress plugin | how to restore xml wordpress backup | how to restore wordpress blog sql | how to restore my wordpress site into earlier time | how to restore a wordpress xml backup | back up wordpress
  • Adding plug-ins to wordpressI am browsing the web for some plug-ins to add...
  • Multiple WordPress Blogs Under One WordPress FolderMultiple WordPress Blogs Under One WordPress Folder By Allen Michael...
  • Back up your blog using wordpress admin panelNow for the second guide to doing a back up...
  • Back up wordpress using a plug-inToday, I’m going to be discussing on how to back...
  • Using Phpmyadmin via wordpress dashboardI am always looking for ways to add more features...
  • New Solutions: WordPress can’t write any files on my webhostProblem: Why can't wordpress write any files on my webhost?...
  • Is your blog ready for WordPress 2.3?The official launch date of WordPress 2.3 is just around...
  • How do you upgrade to wordpress 2.3?When doing your upgrade to wordpress 2.3 , I suggest...
  • warning your backup directory is not writable – wordpress errorwarning your backup directory is not writable I have been...
  • WordPress Automatic Upgrade Plug-in upgraded my blogWordPress 2.5 has just been released last week and today,...
    • Posted in All on Blogging, Wordpress on Aug 10th, 2007 by Allen Gurrea   

    6 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

    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

    3. Allen (1021 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. :)

    4. Backing Up and Upgrading to Wordpress 2.5 | SimplyDunn.net
      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 [...]

    5. Kayla Hernandez (1 comments.)
      May 1st, 2010 | 7:10 pm

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

    6. Callum Harris (1 comments.)
      May 14th, 2010 | 6:55 pm

      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*,~

    Leave a reply
    		 
    | |