Restore MySQL Database With cPanel Backup Tool

With the Backups tool in cPanel, you may generate, download or restore backup files, MySQL databases and email domain forwarder /filter. It is recommended to download the backups to your local machine as a backup.



You may refer to the step below on how to restore MySQL database from cPanel.


1. Login to your cPanel at http://domain_name/cpanel/ or http://domain_name:2082





2. Click on the Backup icon.



 



3. Choose on the option Restore a MySQL Database Backup.



 



Browse to the MySQL database backup file you have on your local machine then click on upload button.



4. Wait the operation to restore the MySQL database to be completed. 

    (Note: This might take several minute which depend on your MySQL database backup file size.)



5. Once completed, you may have to reassign the corresponding database user to the MySQL database again.



To assign the database user to a MySQL database, you may go back to the main page of the cPanel.


1. Click on MySQL databases.



2. Browse to Add Users To Databases: section.

 


3. Choose the corresponding user and database, click on Add User to Database.



Note:


If you have any error message prompt when upload your MySQL database backup file, kindly contact

our Support.


If your backup file larger than 20MB, kindly upload your backup file to anywhere of your hosting 

account and contact our Support to request restore MySQL database and let us know the 

location of the backup file located.





Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.