MySQL Database Processing Settings

MySQL Database Processing Settings IMPORTANT

MySQL tables that use the MyISAM storage engine must be locked to keep them in consistent state while Veeam Agent is creating the system snapshot. To correctly process such tables, MySQL account must have the following instance-wide privileges:

  • SELECT. This privilege enables Veeam Agent to access tables' metadata and select for a lock the tables that use the MyISAM storage engine. Without this privilege, the processing of the MySQL database system will run successfully but MyISAM tables will not be locked, which may result in an inconsistent state of the backed up data.
  • LOCK TABLES. This privilege is required for locking the selected MyISAM tables. If some MyISAM tables are selected but the MySQL account does not have the LOCK TABLES privilege, the processing of the MySQL database system will fail.
  • RELOAD or FLUSH_TABLES. If some MyISAM tables are selected but the MySQL account does not have either RELOAD or FLUSH_TABLES privilege, the processing of the MySQL database system will fail.

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

To specify processing settings for the MySQL database system, do the following:

  1. In the Specify advanced job settings window, 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