How To Backup Your SQL Database

You’ve heard it over and over again- backup, backup, backup! The importance of backing up your site goes unseen until a problem arises. Instead of barking the need to backup your site to you (because you already know that, right?) I’m going to show you how to backup your SQL database. For the purposes of this tutorial, I’m going to backup my WordPress database and show you how I do it.

As I’m sure you know, all of the content within your blog resides in the database- not the files. If you don’t backup your database, you risk losing every post, page and comment in your entire blog. Your admin interface may differ depending on your webhost, but for the purposes of this article, I’ll be using cPanel.

First, login to your site’s cPanel and click on the “MySQL Databases” icon. Scroll to the bottom of that page and click on the “phpMyAdmin” link.

On the left side of the screen, you will notice a drop down menu. Use that menu to select the database you wish to backup.

Once you select your database, you will notice some tabs towards the top of the screen. Click on “Export”.

Next, on the left side of the screen you can select which tables to export. Click the “Select All” link. Be sure all the tables are selected.

Towards the bottom of that screen, click the “Save as file” box, and name the file something you can easily remember.

Click the “Save” button to save the file to your computer. Congratulations! You have just saved a copy of your database. Keep it in a safe location. If you ever need to restore a backup at a later date, click on the “Import” tab on the same screen you just clicked “Export” and select the database backup file you wish to restore to.

This should be a part of your regular routine. How frequently you decide to backup your database depends on you. The busier your blog is, the more frequent you should backup your database. Don’t wait until it’s too late to set 5 minutes aside for regular website backups!

I know this short tutorial may seem elementary for many of you, but now if you’re blog crashes I can say “I told you so”!

2 thoughts on “How To Backup Your SQL Database

  1. Nice simple tutorial. I finally learned how to do this about a month ago after weeks of trial and error.

    This would have come in handy for me then :)

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>