How to Manually Backup Your Database the Best Way

Okay! Backing up our blog’s database is compulsory and should be done regularly, why? Because, it’s the only sure means that guarantees the safety of our blog.

How to Manually Backup Your Database the Best Way

Sometimes, our blog malfunction either because we did a new WordPress update and or due to some plugins that uses database to work.

Believe me, if you have a problem with your blog database, the only way you can get it fixed, is by doing a restore. And if you don’t have a restore file, then maybe your host might have one for you, but that might not be in your favor.

Must Read: 10 Essential WordPress Plugins for the Absolute Beginner

Wait, are you using a plugin to back up your blog’s database? Then, I am sorry to tell you that you’re not safe. Using backup plugin to backup your blog is one of the most dangerous ways to do a proper backup. When using a plugin, sometimes, your backup file might not save properly or it might even corrupt.

How to Manually Backup Your Database the Best Way

WordPress blogs are getting hacked on a daily basis, so doing a full backup of your blog or your database is one sure way of being safe.

Would you like to know how to manually backup your Database the best way without ever worrying about any database error, crash or whatsoever? Then, this short tutorial is for you :)

My simple step of backing up my database

First login to your “Control Panel” Popularly called “C-Panel

In your C-panel, scroll down to your “Files” section and click “Backup Wizard”. See image below…

How to Manually Backup Your Database the Best Way

Have you clicked it? If yes, it will take you to a new page. Seeing the new page? Click the “Backup” button to take you to the next step…

In this step, you have two options of backing up your blog. You can either do a “Full backup” of your blog or you do a “Partial Backup”.

Must Read: Embed pdf Document to Your WordPress Blog Without Plugin

The Partial backup allows you to select the particular backup to download. The three options that are in the Partial backup are: “Home Directory”, “MySQL Databases”, and “Email Forwarder and Filters”.

Now, since we are backing up our Database only, we are going to click “MySQL Databases”. See image below…

database-backup

Have you clicked the MySQL Databases? if yes, you will be directed to a page where you’ll download your Database. Now simply click the Databases you want to backup.

If you click the preferred Database you want to download, it will start the download immediately.

Note: The time of your download depends on how large your blog tables are :) .

After downloading it, you can now be rest assured that the key to your blog safety is safe and sound.

Restoring your database without problem…

Incase you ever have a database trouble/ issue; you can easily restore it back to the last backup download you did. And how do you restore it?

Simply Login to your C-panel and go to the “Files” section >>> Click “Backups”.

In the backup section, scroll down to “Partial Backups” area… there, you will see something exactly like the image below.

database-backup-2

Now click the “Browse…” button to locate your database file.

Note: Your database file is in a zip format with the .gz extension

Click the upload button and you’re there…

Now you know how to manually backup and restore your databases the best way, feels sweet right…

Over to you

It looks like I have said so much about so much, now it’s time to pass the keyboard to you my friends.

Must Read: PayPal is Live in Nigeria and 9 Other Countries: How to Get a Verified account

Do you backup your blog’s database? If yes, how do you do it? Please, we would like to hear from you. Do use the comment box below to drop your views. Remember that your comments, questions, and thoughts are highly welcomed and much appreciated.

Be Social

Was the post good enough? Please, do share the post with your friends and I bet they will appreciate it.

Owww!!! Do not forget to subscribe to our feed for your latest and most fresh updates on the go.

Don't Miss Any Post Again. Subscribe To Our Feed And Be Updated

Enter your email address below:

 

Powered by OnenaijaBlog

Comments

  1. says

    Simplest way to backup the data base I guess. And we can also backup database by using some plugins for wordpress I think. However this method don’t need any plugins.

    Thanks

    • says

      Hello Dave,
      Using plugin is dangerous and not advisable. Because sometimes, the backup file your plugin generate, might get corrupt and that’s bad.

  2. says

    Hi babanature,
    Not to lie, I already knew about this but it will be a great post for beginners as blogs of beginners are hacked easily by hackers.
    Although its simple, I use a wordpress plugin for this purpose which automatically makes backup everyday and send it to my email.
    Good Tutorial!
    A must for all newbies.

    • says

      Hello Anurag,
      It’s good to know that you do know this process… Plugin do make job easier but it can not be trusted with a duty as heavy as keeping your blog safe. I wouldn’t advice people to use a plugin for your backups.

  3. Bello says

    Hello Babanature,
    This is indeed a nice post every new blogger should know.
    I stop using plugin to backup my blog a while ago because a backup plugin almost ruin my blog. I mean, i thought the plugin had backup my blog but little did i know that the files were corrupt. I tried to restore but know way, thank goodness my host provider came to my rescue if not, i’d have been doomed :)

    Your tutorial is always helpful. Loved how you explained it and for that, thanks for this (I truly need it)

    Have yourself a nice weekend ….

    • says

      Hello Bello,
      Long time no see buddy :) . . .
      Wow!!! backing up our blog is compulsory and its what guarantee the safety of our blog. you learn not to backup your blog using plugin through the hard way and that’s bad.
      Atleast now you know how to backup your blog without problems…
      Thanks for stopping by and do have a wonderful weekend

  4. says

    Hi Babanature,

    It’s a great tutorial (again) from you. :)
    Yes, I agree with you. Data backup is so we need as a blog owner. Well, there is no guarantee that tomorrow is no accident that will make us lose the data from our blog.

    I know this is a good tips because this is the first time I knew about it. Thanks for this tutorial Babanature!
    My knowledge Increased after reading your article as well. :)

    Hoping you have a splendid weekend.

    Nanda
    Nanda Rahmanius recently posted…6 Simple Ways To Lose Your ReadershipMy Profile

    • says

      Hello Nanda,
      Glad you learned something new here today. Backing up our blog on a regular bases should come first because as i said earlier, it is the only thing that guarantee the safety of our blog.

      Thanks for your lovely comment.. i am have a great weekend and i hope you’re doing too :)

  5. says

    Hello B Nature !!
    I love your post as I would that It is always recommended you do a blog back up because you never can tell when the unfortunate would come at you with full force. It is one thing a lot of bloggers are ignorant about… On the other way I think people with Google Blogger are always secured from hackers especially if they have two way access activated….. It is a nice tutorial you have here !! I would like to include a back up system for bloggers.. located here ..

    This tutorial also help people using blogger to know how to back up their blog.. Please note that it is very important one backs up his or her blog for security reasons….

    Regards,
    DOK Simon.

    • says

      Hello Simon,
      It is good to backup our blogs whether you are using the wordpress or the blogger platform. Because we never know when something bad will happen to our account, right?

      Thanks for stopping by and dropping your comment, do have a wonderful weekend

  6. says

    nice post and well explained. I’m using a WordPress plugin for this but we must know how to backup our blog manually because plugins start doing mistakes some times. I use to take a manual backup on monthly basis and use my plugin for daily backups.

    Thanks Gaurav

    • says

      Hello Gaurav,
      You are indeed taking a nice precaution towards your blog safety.
      I love your method, it shows you are in control of everything :)
      Thanks for the comment and do have a beautiful weekend…

  7. stella gakuo says

    Hi Babanature,
    This post is just on top at least for newbies like me.The tutorials will help me backup my blog.

  8. says

    Hey Babanature,

    I use the “Backup” and the “File Manager” sections to back up my stuff. I do the full backup once a month but I backup my database and my blog/files daily. I’m one of these better safe than sorry people.

    I’ve never had to load the files back myself, my hosting service has done that for me. I’m sure it’s just as easy as backing it up as reinstalling it all.

    Thanks for sharing this because I think a lot of people are just scared to do something they aren’t comfortable with doing. So many people still don’t even go into their cPanel. The way you showed us is simple.

    I’ll be sure to share this as well.

    ~Adrienne
    Adrienne recently posted…Please Tell Me You Date Your Blog PostsMy Profile

    • says

      Hello Adrienne,
      I learned to back up my blog regularly the hard way, after almost loosing my blogs files :) . I routine backup is healthy for a blog. Backing up our blog is the one thing that truly guarantee the safety of our blog :

      You are right, there are many bloggers who find it hard to access their blog c-panel because they are afraid not to get their blog files destroyed :)

      Thank you for saying that dear friend. And i hope your network would love it as well :)
      Thanks for stopping by and dropping your wonderful comments as always. do have yourself a sound weekend
      babanature recently posted…Here’s How to Grow Your Email List 3 Times Faster – WPSubscribers ReviewMy Profile

    • says

      Hello Neamat,
      Yeah, it is good to do a full back and it is also a brilliant idea to do a partial backup, why? Because the full backup can only be restored by your host providers while the partial backup can be restored by you. So you see why it is good to always do a partial backup :)
      Thanks for stopping by and dropping your comment. Do have a wonderful weekend

  9. says

    Hi Baba,
    Here you have posed a helpful and informative article!!! :)
    Sounding like easiest and best way to back up our data manually, Honestly I’m totally unaware from this but after reading your post i learned lot of new things.
    Thanks for sharing.
    Keep posting.

    • says

      Hello Addison,
      It is good you stop by my blog to learn something important as this one. The reason we need to always backup our blog database, is simply because we need to secure the core of our blog :)

      Thanks for stopping by and do have a wonderful weekend

  10. says

    That’s a really great post Babanature.
    Losing data from your blog is the worst thing that can happen to a blogger and you have shown a simple way to prevent that by taking regular backups.
    Frankly speaking, I have take backups directly using the Import/Export option in the WordPress dashboard as it is easier for me.
    What do you say about that? Is there any problem with my method?

    • says

      Hello Arbaz,
      I only take blogs data from the “import/export” option when i am migrating a blog from one url to another but haven’t thought about using it as an internal backup. You have come up with a good strategy of backing up our blog the easiest way.

      Thanks for stopping by and dropping your wonderful contribution. Do have a wonderful weekend

  11. says

    Superb tutorial Babanature.

    I wanted to point out because I see you’ve used Incase” instead of “in case”, as per context “in case” should be used not “Incase”.
    Correct me if I’m wrong. We’re people we do mistakes all the time! Sorry for late visit, I’m overwhelmed for more than a month, hope to get back in track at the beginning of september.
    I. C. Daniel recently posted…iPage vs FatCow vs JustHostMy Profile

  12. Sandra says

    Hi there! When we make a partial backup at godaddy, the download is corrupt.

    We have tested this. Just download the .gz use 7zip to unzip and you get the .tar file. Try to unzip and you see it is corrupt.

  13. says

    Hi babanature,

    I heard from somewhere that for website backup, Plugin is a great way. but after reading this post, we can not take risk of it. Manually backup is great.

    Thanks babanature for sharing such great tips.

    Areesha Noor!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

CommentLuv badge