The Xopero application allows to direct backup of MySQL databases for users of Advanced license without having to install additional components. To correctly configure the project of backup is necessary to have access data to the server.
Supported versions from 5.0 and above.
Creating backup set
In order to create the MySQL database backup set you need to open Xopero and run the Backup set wizard by clicking on New backup set button in My backup sets tab.
In the Backup set wizard mark Advanced copy and select MySQL from dropdown list. Don’t forget to define the backup set name.
In the MySQL panel you need to define parameters that are necessary to connect with the database server:
- Address - address IP of the computer with MySQL server,
- Port - port, on which the database server is listening,
- User - MySQL database username,
- Password - password for user above.
|The user indicated in the application Xopero must have the necessary privileges to backup databases to MySQL server. Information about the required permissions are available at https://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/mysqlbackup.privileges.html|
If the above data are correctly entered, the Xopero application connect to the database server and in the field Database will be available list containing all accessible databases. You have to choose one of them.
After the correct configuration of connections to the database server and indicating the database backup, click on the button Test Connection to check the connection to the database.
|To enter additional connection parameters to the database server, such as timeout, mark Advanced which create an Connection String where you can enter the required parameters.|
In case of editing Connection String enter the the correct password MySQL user in place *** specified with parameter Pwd.
In the end define Temporary directory, that is the directory to which will be dump the database. Clicking on the button Save creates a new project of backup.
Restoring MySQL database
Restore MySQL database, which has been backed up using the application Xopero takes place in two stages. In first stage, using the Xopero application, download a dump of the database on the user's computer. The second stage is the restore the database to the MySQL server, using third party tools.
Downloading a database file from backup
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.
The tool mysql is available for download: https://dev.mysql.com/downloads/utilities/
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.