How to restore database with Snel Cloud Backup

Learn to restore databases with Snel Cloud Backup

In this article, we will provide you with the steps to perform a database restore.

Prerequisites

• Snel Cloud Backup
• Installed database server MySQL / MariaDB
• A protected item that covers the database server

Step 1: Log in to Snel Cloud Backup Console

Go to https://backup.snel.com/ and log in with your credentials.

Step 2: Restore

Click “Restore”

Select from which servers data you want to restore, you can use the dropdown menu ” Please select an online device to control:” to see the server overview. Once the server is selected click “Next >”

Select from which backup you want to restore and click “Next >”

In our case we do want to restore a single database, select “Select Items…”. You will see all the databases, select the database you want to restore and click “Next”

Change “Files and Folders” to “Program Input”. Enter the following commands:

DirectAdmin

mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf -u da_admin

Plesk

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa

cPanel

mysql -h 127.0.0.1 -u root

without Panel

mysql -h 127.0.0.1 -u root

Once the command is entered click “Restore”.

Step 3: Optional restore process

If you want to keep track of the restore process, click “History -> Job History” in the menu. Find the backup process with type “Restore” and click “Report”.

Conclusion

This article has described how you can restore a database from a backup.