With the Backups tool in Cpanel, you may generate, download or restore backup files, MySQL databases and email domain forwarder/filter. It is recommended you download the backups to your local machine as a backup.
You may refer to the steps below on how to restore MySQL database from CPanel.
1. Log in to your Cpanel at http://domain_name/cpanel/ or http://domain_name:2082
2. Click on the Backups icon.
3. Choose on the option "Restore a MySQL Database".
4. Browse to the MySQL database backup file you have on your local machine, then click on the Upload button.
5. Wait for the operation to restore the MySQL database to be completed
(Note: This might take several minutes, depending on your MySQL database backup file size).
6. Once completed, you may have to reassign the corresponding database user to the MySQL database again.
7. To assign the database user to a MySQL database, you may go back to the main page of the CPanel.
8. Click on MySQL databases.
9. Browse to "Add Users To Databases" section.
10. Choose the corresponding user and database, then click on "Add user to database".
Note:
1. If you have any error message prompt when you upload your MySQL database backup file, kindly contact support.
2. If your backup file is larger than 20MB, upload your backup file to anywhere on your hosting account.
Then contact our support deportment letting us know the location of the backup.
- 135 Users Found This Useful
Related Articles
Do you support ASP pages and Access databases?
Unfortunately, we do not. We currently only support MySQL, PHP, CGI, and Perl.
What are the basic connection settings for MySQL?
There are two different ways to connect to a MySQL database. Locally (from a script on the...
How do I create a MySQL backup?
You can take a backup of your MySQL databases using phpMyAdmin. To do this, follow these...
What version of MySQL are you running?
We are currently running 5.0.45.
