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.
Step 1
Create a MySQL backup for sampleDatabase
(as an example).
Step 2
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.
Step 3
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"
Step 4
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.
Step 5
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.