You can create a partial backup of your hosting account using the cPanel Backup Wizard. Downloading a copy of a MySQL database is one of the methods for producing a partial backup. This guide will help you to restore a database backup that you produced using the Partial Backup option in the cPanel Backup Wizard.
Step-by-Step Procedure to Restore a Backup:
- To begin, go to your cPanel account.
- Select the Backup Wizard icon from the Files area of the cPanel home page.

- Click the Restore button on the right side of the page.

- Select MySQL Databases from the Select Restore Type drop-down menu.

- Click the Choose File button on the Restore tab.

- Click Open to open the database backup file on your local computer.
- To begin the database restoration, click Upload.

Note: A new browser tab will open displaying the database restoration progress. Once the restoration is complete, a confirmation message will appear at the bottom of the page.
By following the steps outlined above, you can successfully restore a MySQL database backup using the cPanel Backup Wizard. Restoring a database correctly is essential to ensure your website functions as expected after data loss or migration.
If you encounter any issues during the restoration process or need further assistance, feel free to contact the support team for 24/7 help. They will be happy to assist you in resolving any concerns. You can also check out cPanel web hosting plans.