Restoring Databases

If the database already exists and you only need to restore its contents:

  1. Go to Domains > domain name > Databases > database name > Database Backup Repository, select the required backup file from the list and click Restore.

    If you do not have the backup file on your server, you can upload the backup file to the server repository from your local machine. Refer to Uploading Database Backup Files To Server section for more information.

  2. Confirm the restoration by selecting the corresponding check box and click OK.

    If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them. Refer to Recovering Orphaned Database Users section for more information.

If the database does not exist and you need to recreate it from scratch:

  1. Go to Domains > domain name > Databases and click Add New Database.
  2. Specify the database name, type and server for the database you are restoring.

    Note. You can specify a new database name, but you must choose the correct database type: for example, if you are trying to restore a MySQL database, choose MySQL database type.

  3. Select the Restore database from backup file check box.
  4. Specify the location of the database backup file. You can upload a backup file from your local machine or specify a file located on the server.
  5. Provide the default username and password for the restored database.
  6. Click OK.

    If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them. Refer to Recovering Orphaned Database Users section for more information.

In this section:

Recovering Orphaned Database Users