You can restore a MySQL database from a backup file directly within the WHM interface. This process allows a Server Administrator to restore a specific database to its previous state using a backup generated by the server.
Before you begin
You will need:
Server Administrator access to WHM
A valid MySQL database backup file (e.g., a
.sqlor.sql.gzfile)The exact name of the database you wish to restore
Restore the MySQL database
Log in to WHM.
Navigate to Home > Restore_Backup > Restore a MySQL Database from a WHM Backup.
Select the Account that owns the database from the dropdown menu.
Select the Database you wish to restore from the list.
Select the Backup file you wish to use for the restoration.
Click Restore.
Confirm the result
Once the process is complete, the system will display a success message. You can verify the restoration by:
Checking the database size in the MySQL Databases interface to ensure it matches the expected size.
Logging into the database via a management tool (such as phpMyAdmin) to confirm the tables and data are present.
If the restoration fails
If the restoration fails, check the following:
File Integrity: Ensure the backup file is not corrupted and is in a format compatible with MySQL.
Database Name: Ensure the database name matches the one intended for the account.
Permissions: Verify that the account has the necessary permissions to access the database.
If the issue persists, contact Hostek support with the specific error message received during the restoration attempt.
Limitations
This procedure only restores the database from a backup that was previously created within the WHM system.
Restoring a database will overwrite any existing data in the target database.
This process does not restore the database's user permissions; those must be managed separately if they were changed after the backup was taken.
