MySQL Specific Configuration

Enterprise

Bacula Enterprise Only

This solution is only available for Bacula Enterprise. For subscription inquiries, please reach out to sales@baculasystems.com.

In order to use Point-In-Time Recovery feature of MySQL, you need to enable log_bin in the MySQL configuration file and then restart the MySQL server. The procedure may differ between major MySQL versions, so we advise you to read the MySQL documentation corresponding to your server version.

log_bin = hostname-bin

or

log_bin = /U01/hostname-bin

If you change the log_bin parameter after a Full backup, you will need to schedule a new Full backup to back up binary logs in Incremental level properly.

The Bacula Enterprise MySQL Plugin usually is able to detect the log_bin path, however, in some cases you might need to specify the mysqld configuration file using config_file or the logbin_dir plugin command option.

By default, the MySQL Plugin uses the root account to dump and read MySQL files. On some systems, it is possible to use the mysql account. However, on RedHat systems, this account is locked and this is not possible.

See also

Previous articles:

• Automatic Objects Integration

Next articles:

• Binary Mode Configuration

• Binary Mode Options

• Dump Mode Configuration

• Dump Mode Options

• MySQL Connection Information

• Testing Database Access Configuration

• Error Log and Debug Information

Go back to: Configuration.