As promised in my previous article, this one will be about the easy way to make a database backup using cPanel. Do it, and do it regularly to protect your information and to prevent yourself from losing your data.
When I started working online, just like many other people I had no clue about how to do a database backup using cPanel or why I should backup my WordPress files regularly. I was scared when I heard about cPanel, FTP, FileZilla, add-on domains, subdomains and all the other confusing stuff other people seemed to know
so much about, but me.
Well, there were two ways to deal with that. First: to learn and do it, second: outsource and never know what happens with my sites when something goes wrong.
And, because I like to know what happens with my sites and I want to be able to get things “repaired” if they
don’t work properly, I started learning. I went on webinars, studied home courses, watched videos, talked to colleagues, etc. etc. What I’ve noticed though was that if I asked 3 people I had 5 opinions on what to use and how to do it – what made me even more uncertain.
So I went back to the basics, back to the roots again. What I show you today are some of those basics you need to know about if you want to understand how your site works. We’re getting started with a screenshot of the cPanel in my Hostgator account. It does not make much difference if you have another hosting service because the cPanels look pretty much the same.
How to do a database backup using cPanel?
On the Home page of you cPanel you’ll find all the icons which lead you to the tools you need. Look for the icon named Backup Wizard and click on it. The next page looks like this:
For the database backup using cPanel, simply click Backup at the bottom of the page.
If you need to restore your files from a backup, click on Restore.
What is a database backup?
A database backup is a zipped copy of your entire site or parts of it. It comes as a .zip file that you can download onto your computer. Make sure that you store it somewhere where you can access it easily. To me, the easiest way was to create a folder on my desktop and store all the backups for each one of my sites in that folder.
The following are backed up and included in the .zip file:
- Home Directory
- MySQL Databases
- Email forwarders configuration
- Email filters configuration
What’s the next step in creating a database backup using cPanel?
On the next page you can choose between a Full Backup and a Partial Backup:
The Full Backup allows you to create an archive of all the files and configurations on your website.
Note: Full Backup can only be used to move your account to another server, or to keep a local copy of your files. You cannot restore Full Backups through your cPanel interface.
The Partial Backup includes your Home Directory, the MySQL Databases and the Email forwarders.
These backups are the ones you should download and use to restore your data if something went wrong.
What’s the final step when doing a database backup using cPanel?
The third and final step is the Download. Here you can download the files of your Partial Backup: the Home Directory, the MySQL Databases, the Email forwarders.
As you see, it’s really easy to make a database backup using cPanel.
There are lots of information about database backup using cPanel out there. Also, there are a huge amount of videos on Youtube and other platforms, providing detailed information.
If you want to watch the videos on how to make a database backup using cPanel, here is the link to Youtube. Many of these videos are not the newest ones, most of them are more than 6 months old. I didn’t watch them,
so I cannot tell you anything about the quality of the information they provide. Please also take a look at the date of the uploads because some of them might be outdated.
Another quick tip if you have problems with cPanel: do not hesitate to contact your hosting service. Many hosting services provide live support and a Q+A section, use that. They will help you when you’re still not sure about how to make a database backup using cPanel and with any other problems related to your account as well.
If you have trouble with your site and you’re not sure what to do, contact them first. Save yourself a lot of time and prevent yourself from doing things the wrong way.