Skip to main content

How to Restore a Customer Database From a Server Backup

You can restore a specific MySQL or MariaDB database for a customer account using a backup file from the server. This process allows you to recover lost data or restore a database to a previous state within the WHM interface.

Important: This feature is only available on specific Hostek plans and requires the appropriate permissions from your server administrator.

Before you begin

You will need:

  • A WHM account with Reseller privileges

  • A valid MySQL or Maria10 database backup file (typically in .sql or .sql.gz format)

  • The exact name of the database you intend to restore

Restore a customer database

  1. Log in to WHM.

  2. Navigate to Home > Restore > Restore a MySQL Database from a Backup.

  3. Select the customer's account from the list of available accounts.

  4. Select the specific database you wish to restore.

  5. Upload the backup file or select the file from the server's storage.

  6. Click Restore.

Confirm the result

  • The system will display a success message once the restoration is complete.

  • You can verify the restoration by logging into the customer's cPanel and checking the database size or content via phpMyAdmin.

If the restoration fails

If the restoration fails, check the following:

  • File Size: Ensure the backup file does not exceed the maximum upload limit allowed by the server.

  • File Format: Ensure the file is a valid SQL dump.

  • Database Name: Ensure the database name matches the one assigned to the customer account.

If the issue persists, contact Hostek support with the specific error message and the name of the database involved.

Limitations

  • This procedure only restores the data within the specified database; it does not restore other items like email accounts or file system data.

  • The restoration will overwrite any existing data in the target database.

  • This feature is dependent on your specific Hostek plan and the features enabled on your account.

Did this answer your question?