If the database already exists and you only need to restore its contents:
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.
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:
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.
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.