How to restore a MySQL database backup in cPanel?
A database restoration is an action usually performed after problems have occurred in your database and possible data loss. It is possible of course you might be transferring from another server, so you basically install the database on your site.To restore your database through backup, you should initially have such a copy in your possession.
To restore your database from a backup, you should primarily have such a copy of your database.
It is important to specify that the backups created in cPanel contain the command DROP TABLE IF EXISTS. This means that the restoration process will delete all common tables among the Database and the File backup, so you should be really certain that you are not interested in the current state of your database before going on with the restoration.
Restore database on cPanel
- Login to cPanel
Click the Backups option you will find in the Files section.
In Restore a MySQL Database category click the Choose File option.
Choose the backup file of your database in your computer.
Click the Upload option.
The restore process may be slow, depending on the size of the database. Small databases can be restored in seconds.