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
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.
Leave a Reply