How to restore database with Snel Cloud Backup

Estimated reading time: 1 min

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

When using a control panel the database as the user should exist. Otherwise, you will not see this in the control panel.

Click “Restore”

restore button

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 server

By default only the latest recovery point will be shown. To see all recovery points click “Refresh”

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

database restore

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”

select database

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.

Was this article helpful?
Dislike 0
Views: 15

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

snel-knowledgebase