MySQL Plug-in: Configurations

To perform backup or restoration with the MySQL plug-in, you need to create a configuration defining how to connect to your databases. The configuration dialog looks as follows:

Configuring MySQL plug-in

Configuration dialog for the MySQL plug-in.

To create a configuration for the MySQL plug-in, follow these steps:

  1. Click New configuration during creation of a backup or a restore task. The Settings dialog opens.
  2. In the Configuration field, enter a name for the configuration.
  3. In the Host field, enter host name or IP address of your MySQL server.
  4. In the Port field, enter port number to connect to MySQL. The default port is 3306.
  5. In the User field, enter MySQL user name.
  6. In the Password field, enter MySQL password.
  7. Click Test connection to verify that all fields are filled correctly.
  8. When finished, click OK.

The MySQL user must have sufficient privileges to perform the desired actions:

  • To open plug-in listings, browse through the list of databases and select data to be backed up, the MySQL user must be allowed to run the SHOW DATABASES and SHOW TABLES statements.
  • To create backups, the MySQL user must have the privileges to run the SELECT statements for each database and table that you want to back up.
  • To restore data, the MySQL user must have full privileges to drop databases and tables and restore them from zero.

User Manual contents

Who uses our backup software?