Specifying MySQL Processing Settings

You can enable MySQL processing settings in the properties of a volume-level backup job configured in Veeam Agent for Linux.

Specifying MySQL Processing Settings Important!

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

  • SELECT for all tables. If you do not have the SELECT privilege for the table, Veeam Agent does not process the table.
  • LOCK TABLES. If you do not have the LOCK TABLES privilege, Veeam Agent does not process MyISAM tables.

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.

To enable MySQL processing settings for the backup job, use the following command:  

veeamconfig aap set mysql --jobId <job_id> <mysql_options>

or

veeamconfig aap set mysql --jobName <job_name> <mysql_options>

where:

  • <job_id> — ID of the backup job for which you want to enable MySQL processing settings. You should look up the job ID in advance, before configuring MySQL processing settings, for example, with the veeamconfig job list command. To learn more, see Viewing List of Backup Jobs.
  • <job_name> — name of the backup job for which you want to enable MySQL processing settings.

 

Specifying MySQL Processing Settings Tip:

To view IDs or names of all existent backup jobs, you can press the Tab key right after you type the --jobId or --jobName option.

MySQL Processing Settings

You can specify the following MySQL processing settings for the backup job:

Option

Description and values

--tryProcess

Defines that Veeam Agent must continue the backup process if errors occur when processing the MySQL database system. If you do not specify this option, Veeam Agent will stop the backup process if an error occurs when processing the MySQL database system.

--usrMysqlDb

Name of the MySQL account. Veeam Agent can connect to the MySQL database system in one of the following ways:

  • If you specify account name (--usrMysqlDb option) only, Veeam Agent will prompt you to specify a password to access the MySQL database system.
  • If you specify account name and password (--usrMysqlDb and --password options), Veeam Agent will access the MySQL database system.
  • If you do not specify account credentials (--usrMysqlDb and --password options), Veeam Agent will use a password file to connect to the MySQL database system. To learn more about password file configuration, see Preparing Password File for MySQL Processing.

--password

Password of the MySQL account. If you do not specify the --password value, Veeam Agent will prompt you to specify a password to access the MySQL database.

Keep in mind, if you specify the password using the --password option, password is stored in terminal in plain text.

--defaults-file

Path to a password file. You must specify a full path to a password file if you want Veeam Agent to use a password file located in specific directory. Specifying relative paths is not supported.

With this method selected, you do not need to specify account credentials in the backup job settings.

You do not need this option in the following cases:

  • Veeam Agent uses account name and password that are specified in the backup job settings to connect to the MySQL database.
  • Veeam Agent uses account credentials that are stored in the password file in /root/.my.cnf.

 

Examples

Authentication with password:

user@srv01:~$ veeamconfig aap set mysql --jobId 29bc2e1a-e35c-4efb-8d37-b7177b8ea75 --tryProcess --usrMysqlDb root --password P@ssw0rd

Authentication with password file:

user@srv01:~$ veeamconfig aap set mysql --jobId 29bc2e1a-e35c-4efb-8d37-b7177b8ea75 --tryProcess
--defaults-file /data/root/.my.cnf --password P@ssw0rd

I want to report a typo

There is a misspelling right here:

 

I want to let the Veeam Documentation Team know about that.