I personally do not recommend using it or relying on it as your primary means of backing up your database. Should the need arise for you to actually restore a backup and your Administration area is inaccessible it's not going to do you much good if you can't restore it.
For a better, more reliable, stable and solid backup solution you should perform backups at the hosting level using your hosts control panel. Become familiar with how to download and restore in your hosting control panel.
My preferred hosting control panel is Cpanel. It is very popular and used by many hosting companies. There is a certain level of learning required, but it is fairly easy to get the hang of. If you ever wanted to switch hosts and they both use cpanel, transferring your site from one to the other can be done very fast. Many will even do it for you for free if you decide to switch to them.
The screenshots below are from a standard default cpanel setup. If your host has cpanel they could look slightly different. Some hosting companies use color skins and/or logos that can make them appear slightly different. Just look for similar areas and icons in your hosts cpanel.
1. Login to cpanel.
2. Find and navigate to the "Files" area and choose "Backups".
3. Find the Partial Backups area and the "Download a Home Directory Backup". Click on the "Home Directory" button.
It will prompt you to download and ask you where you want to save it. A good location to save to is your desktop so you can find it easy.
This will download all your files and folders in 1 compressed file, usually a .tar.gz format type.
Do not use the "Full Backup" ("Download or Generate a Full Web Site Backup") area or button.
That is if you want to move or transfer to another host. It is only restorable by your host, not you in cpanel. And, it will create and generate the backup on the server in your hosting account which you would have to retrieve by ftp or filemanager. So don't mess with it unless you are moving to another host or really know what you are doing.
4. Return to the "Backups" page or screen if you are not already there.
This time in the "Partial Backups" area find "Download a MySQL Database Backup" and simply click on the name of your database in the list. In this case, I just click on "demo_test".
You will be prompted once again to download (your database this time). Again, a good place to save it to would be your desktop.
These are usually compressed too and are generally much smaller in size than the Home Directory backup so it should finish much faster. It will most likely be sql.gz format.
Now keep them in a safe location. You might create a folder on your local pc with a distinct name and place them in there. Perhaps a folder called "sitename-date-backups" or similar.
To Restore a Home Directory Backup in cpanel:
If you need to restore your downloaded Home Directory Backup (all your files and folders).
1. Navigate to the "Backups" page or screen in cpanel again.
2. Now locate "Restore a Home Directory Backup" area.
Click on the "Browse" button to locate the home directory .tar.gz file you downloaded.
Then, click the "Upload" button.
Wait for it to finish.
Once again the time it will take to upload will vary depending on the size of your .tar.gz backup and how fast your internet upload speed is.
Be patient and let it finish doing its thing!
To Restore a Mysql Database Backup:
1. Find "Restore a MySQL Database" area and simply click on the "Browse" button.
Locate your backup .sql.gz file you downloaded and click the "Upload" button.
Wait for it to finish.
Generally your database backup .sql.gz files will be much smaller than a home directory backup unless you have a very huge site. Which means it should only take a fraction of the time to upload compared to a home directory backup. With an average site and internet connection usually only a few seconds to maybe 1-2 minutes to upload a database backup.
Keep good backups in dated folders if possible.
Drop a notepad or other text file in a folder along with the backups that include notes to yourself explaining what the backup contains or was for.
Create a backup before performing upgrades, changes, modifications, etc. so you can restore (especially a database backup) if necessary.
Other - Opening Downloaded Backup Files:
If you would like to open or extract the contents of the "Home Directory Backup" or the "Mysql Database Backup", but you do not have a program capable of handling .tar/.tar.gz formats you can use a very good and free program: