Searching for a way to quickly and easily complete database backup? Creating a backup of your MySql databases using cPanel is a simple task. A full cPanel Backup makes a copy of all of your files, emails, databases, etc. This article will teach you about how you can backup your WordPress database using the cPanel. It is important to backup your website regularly. I personally recommend making a database backup prior before making any modification or migration of your websites. This article shows steps to backup WordPress Database using cPanel.
Backup WordPress Database using cPanel
First you need to login to your WordPress hosting control panel. After you have login to your control panel, navigate to the Files section and click on Backups.
You will be linked to Download a MySQL Database Backup section. Click on your database name under the Partial Backups. In this case it’s kosyslab_ffn. As you see, you can even do a full backup, which includes all the files in your home directory, your MySQL database, and your email forwarders and filters.
A Pop-Up box appears in your screen which helps you to download the .sqp.gz file in the Downloads folder in your Computer. Select the Save File option and click on OK button to start the download.
When the compressed .sqp.gz file is completely downloaded go to Computer > Local Disk (C:) > Users > PC Name > Downloads and you will have the backups .sqp.gz file in the Downloads folder in your computer.
Using cPanel to Backup your databases manually is very simple and if you ever need to restore then its a simple one click process as well. Not all Web Hosts offer backup so you may need to use a Backup Plugin.