MySQL Specific Configuration

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

Go back to:

• Automatic Objects Integration

Go to:

• 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 the Configuration page.

Go back to the main MySQL Plugin page.

Go back to the Dedicated Backup Solutions page.