This is a quick example of how to restore a MySQL database dump of a single database.
WARNING: This restore process will overwrite your database by the backed up copy you are restoring.
Create a MySQL backup for
sampleDatabase (as an example).
Go to your backup page, under the "Backup History" section click the little "i" on the right, click "Database Backup", then click "Raw Download Link" and copy the output.
On your server, run the following command, replace the raw download link you obtained in the previous step:
wget "PasteTheRawDownloadLinkHereBetweenTheQuotes" -O "mysql-backup.sql.gz"
Now that you downloaded the database backup on your server, extract it as shown:
tar -xvf mysql-backup.sql.gz
This will output a single SQL file in this format
db-backup-XXX.sql in the same directory.
Note: the following command will overwrite your
sampleDatabase by the database copy you are restoring. It is a good practice to inspect the backup first before the restore.
Restore and overwrite your by the downloaded backup as shown below by running:
mysql -uYOURDATABASEUSERNAME -pYOURDATABASEPASSWORD < db-backup-XXX.sql
If you need any help in any of these steps, let us know and we can help you with the restore.