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.
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.
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.