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.