To download MySQL database file, you have to start the Xopero application, then go to the tab Restoring. All databases, which have been backed up are located on branch MySQL.
Expand the aforementioned branch, then check the box next to the database which you want restore and click Restore selected.
To restore a previous version of the selected database, click on its name, right-click and select Show file versions.
Settings window restoring will be displayed, where should specify the location to which you want to save the database backup file. Then this file will be used to restore the database on MySQL server.
Restoring the database from the downloaded file
To restore the database on MySQL server you have to use the tool for manage database. For the purposes of this instruction used tool mysql available from the command line.
To restore the database, you need to log in to the database server via the command: msql -h SERVER_ADDRESS -u USER -p, where:
- SERVER_ADDRESS - MySQL server address to which you want to restore the database
- USER - name of the user who has the privilege to restore the database.
The tool mysql requests entry of password the user specified in the command. Correct password implementation will log on to the database server, where you should select the database to which you want to restore the backup, the command USE database_name.
Restore the backup of database is executed by command source FILE_PATH, where in place of FILE_PATH must indicate the exact location of the previously restored the database file.
