How to Back Up and Restore a MySQL Database in cPanel

Date: 18-06-2021

Backup Database:

Step 1: login to cPanel account.

Step 2: Select Backup in the Files section of the main page. You can see all databases associated with your cPanel account.

Step 3: Click on your database in the Download a MySQL Database Backup section and cPanel will generate an SQL file and save it to the default download location on your computer.

Restore Database:

Step 1: Select Backup in the Files section of the main page. You can see all databases associated with your cPanel account.

Step 2: Click Choose File and select an SQL file from your local machine. Click Upload and cPanel will import the file in the Restore a MySQL Database Backup section.

Thank you!