This article contains the detailed instructions on how to perform the following actions on your SQL databases:
All of these features are available in the HostPilot® Control Panel.
Please login to your account HostPilot, expand the menu for SQL server on your account and navigate to Databases, then click on the database name you would like to backup/restore/download/upload:
To backup a database you will need to specify the name for the backup and click Backup button. Your existing database will be immediately backed up and available for restoration/downloading:
The manual backups are stored on one of our backup servers.
- There can be only 3 backups for every database simultaneously. In case you already have 3 backups, please delete one of them before you can make another backup.
- The MySQL database backup file created by Backup feature available in HostPilot contains the original database name.
If you need to restore the database with another name from such backup file you need to:
- Download the backup file to your local machine;
- un-zip the backup file;
- open it via text editor (Notepad, for example);
- in the first lines of the file find 'USE `dbname`;' where dbname is the name of the original database backup file created from, and delete it (or replace the dbname with the name of the database that will be restored from this backup file;
- save the changes.
Now it is safe to restore the database with another name from the backup.
Otherwise your database will not be restored from the backup but database with the original name.
To restore a database from any available backup, please select the appropriate backup and press Restore.
Note: If you need to restore a database but do not have any backups created manualy we can restore one of our standard backups of a database. In such a case, a restoration service fee, as specified in your Plan, will be applied. To request your databases restoration from our standard backups, please submit your restoration request from the Extended Services portal. Read the knowledge base article on SWH Backup and restoration options for more information about this option.
To download a backup file, select a radio button next to the backup name and press Download:
If this is MySQL database, the backup file will be downloaded to your local machine. locate a folder you want to download the backup to and click on Select.
If this is MSSQL database, the backup file will be downloaded to your account FTP server from where it can be downloaded to local computer if needed. You can learn how to connect to FTP server from the article How Do I Access My Server Via FTP?
To upload a backup file, select a radio button next to the backup name and press Upload:
If this is MySQL database, pressing Upload button will allow you to upload database backup file from your local machine to backup server.
If this is MSSQL database, pressing Upload button will allow you to upload a database backup file from your account FTP server to our backup server. Thus, if you have a backup on your local machine, you should upload it to the FTP server first: How Do I Access My Server Via FTP?.
You can also upload databases to MSSQL server using Management Studio Express. Read the Knowldge Base article on How To Upload MSSQL Databases Using Management Studio Express? for more information.
You can only have 3 backups of each database.
If you don’t have your own backups it is still possible to restore the database from the backup that we do automatically. In this case a restoration service fee will be applied. You will need to submit Extended Service request. Read the SWH Backup and restoration options article to learn more about automatic backups.