How to backup and restore MySQL from cPanel?

Step 1: Login to your cPanel Account with your username and password.

Step 2: Search the backup feature by typing the word ‘Backup’ on the search box. Then click on the backup icon to proceed as shown below:

Step 3: Locate your database under the list of databases on the next screen below the option “Download a MySQL Database Backup”. Just click the database that you want to backup as shown below:

You will be prompted to save your database on your computer. You can edit the name of the file or leave it as it is and save it.

Step 4: Now inorder to Restore your MySQL database, find the title, ‘Restore a MySQL Database Backup’ under ‘Account Backups’, then click ‘Choose File’ and ‘Upload’ as shown below

Your database will be successfully restored if there were no errors and you will see a success notification on the screen as shown below: