MySQL Inremental/Differential backup options grayed out (4035139)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

MySQL Inremental/Differential backup options grayed out
Description

In the plugin options of a MySQL backup, the options for doing Incremental and Differential backups can be grayed out and can't be selected.
Cause

If MySQL replication is configured, the supported backup types are limited on the Master replication server.
Resolution

Support for backing up native MySQL Replication environments has the following limitations:
• Slave replication servers – Backup types supported include:
• Full
• Incremental
• Differential
• Individual Database/Table Copy Only
• Masters replication servers – Backup types supported include:
• Individual Database/Table Copy Only
Incremental and Differential Backups on the slave server will require that you enable the “--log-slave-updates”
option in MySQL. This option tells the slave to log the updates performed by its SQL thread to its own Binary
Log. For this option to work, the slave must also be started with the “--log-bin” option to enable Binary
Logging. Normally, this option is used to chain replication servers; however, it can also be used for Binary Log
backups enabling PIT Recovery of a replicated environment without the complications of purging Binary Logs on
the master server before they have been applied to the slaves.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title