MySQL Processing Settings
You can specify how Veeam Agent for Linux must process a MySQL database.
Before you start working on the MySQL tab, check the following:
- At the Guest Processing step of the wizard, the Enable application-aware processing check box is selected.
- At the Guest Processing step of the wizard, in the Application-Aware Processing Options window, a necessary protection group or individual computer is added to the list.
To learn more, see Guest Processing Settings.
- On the General tab, in the Applications section, Require successful processing or Try application processing, but ignore failures option is selected.
To learn more, see Application-Aware Processing.
To specify how Veeam Agent for Linux must process a MySQL database, perform the following:
- At the Guest Processing step of the wizard, click Applications.
- In the Application-Aware Processing Options window, select the necessary object, click Edit and switch to the MySQL tab.
- On the MySQL tab, To specify a user account that Veeam Agent for Linux will use to connect to the MySQL database, from the Specify MySQL account with superuser privileges list, select a user account that has the following privileges on the database:
- SELECT for all tables. If the account does not have the SELECT privilege for the table, Veeam Agent will not be able to access the table metadata. Thus, Veeam Agent will not process the table. To learn more, see MySQL documentation.
- LOCK TABLES. If the account does not have this privilege, Veeam Agent will not process tables based on the MyISAM storage engine.
If you have not set up credentials beforehand, click the Manage accounts link or click Add on the right to add credentials.
By default, the User from password file option is selected in the list. With this option selected, Veeam Agent for Linux will connect to the MySQL database under the account specified in the password file on the Veeam Agent computer. The default location for the password file is /root/.my.cnf. For information about the password file format, see the Preparing Password File for MySQL Processing section in the Veeam Agent for Linux User Guide.
- If you want to specify a custom path to the password file, specify a full path in the Password file path field. Specifying relative paths is not supported.
For information on how Veeam Agent for Linux processes the MySQL database system, see the MySQL Backup section in the Veeam Agent for Linux User Guide.