This is an archive version of the document. To get the most up-to-date information, see the current version.

MySQL Database Processing Settings

MySQL Database Processing Settings Important!

To process the MySQL database system, the MySQL account must have the following privileges:

  • SELECT for all tables. If the MySQL account does not have the SELECT privilege for the table, Veeam Agent cannot access table metadata. As a result, Veeam Agent does not process the table. To learn more, see MySQL documentation.
  • LOCK TABLES. If the MySQL account does not have the LOCK TABLES privilege, Veeam Agent does not process tables based on the MyISAM storage engine.

To obtain information about privileges that are assigned to the account, use MySQL functionality, for example, the SHOW GRANTS statement. To learn more, see MySQL documentation.

At the Advanced step of the wizard, specify processing settings for the MySQL database system:

  1. Select the MySQL processing option with the Tab and Down keys and press Enter.
  2. In the MySQL processing section, select one of the following options:
  • Require successful processing. With this option selected, Veeam Agent will stop the backup process if an error occurs when processing the MySQL database system.
  • Try application processing, ignore failures. With this option selected, Veeam Agent will continue the backup process even if errors occur when processing the MySQL database system.
  1. In the Authentication method section, specify how Veeam Agent will connect to the MySQL database:
  • Select Password if you want Veeam Agent to connect with the MySQL account name and password. With this option selected, you must specify account name and password in the backup job settings.

MySQL Database Processing Settings 

  • Select Password file if you want Veeam Agent to connect with the MySQL account name and password that are stored in the .my.cnf password file. With this option selected, you must specify a path to the password file, but do not need to specify account credentials in the backup job settings. To learn more about password file configuration, see Preparing Password File for MySQL Processing.

MySQL Database Processing Settings