Step 1: Login to cPanel and click phpMyAdmin.
Step 2: Select your database on the left side of phpMyAdmin.
Step 3: A new page will be loaded showing the structure of the selected database. To create a backup of the database, click the Export tab.
On the page that opens you can choose from using the Quick or Custom export methods. The Quick method is usually the preferred choice, but if you would like to customize the export process then you can use the Custom one.
Once you choose the appropriate method, select the desired format of the backup from the Format: drop-down and click the Go button.
A download window will pop up prompting for the exact place where you would like to save the file on your local computer.