In the previous lesson, you learned how to easily generate and download MySQL database backups anytime from the cPanel. Next is how to restore them.

To restore a MySQL database from cPanel, you need to follow these steps:

Step 1: Log into cPanel

Open your browser and log into your cPanel account by entering your username and password.

Step 2: Access the Backup Feature

Once logged in, scroll to the Files section on the cPanel dashboard. Click on Backup or Backup Wizard.

Step 3: Choose the Database Restore Option

Under the Restore a MySQL Database section, locate the Restore a MySQL Database Backup option. Select this to begin the process.

Step 4: Upload Your Database Backup

Click the Choose File button and select the .sql or .gz backup file you downloaded. After selecting the file, click on Upload or Restore to initiate the restoration process.

Step 5: Completion

Once the file is uploaded, cPanel will automatically restore your database. As soon as the restoration is complete, you will receive a confirmation message.

By following these steps, your MySQL database will be successfully restored in cPanel.

You can easily generate and download MySQL database backups anytime from the cPanel, by following these steps:

Step 1: Log into cPanel

Open your browser and log into your cPanel account by entering your username and password.

Step 2: Access the Backup Feature

Once logged in, navigate to the Files section on the cPanel dashboard. Click on Backup or Backup Wizard, both of which allow you to back up your database.

Step 3: Choose the Database Backup

If you’re using the Backup Wizard, choose the option to back up a specific part of your site. Under the Partial Backups section, locate the Download a MySQL Database Backup option. A list of databases will appear; select the name of the database you wish to back up.

Step 4: Download the Backup

After selecting the database, the backup process will begin automatically. Your browser will prompt you to download the .sql or .gz file. Save the backup file to your local computer.

This backup file can be used for future database restoration.