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â€!