13.2 Apply-Log Operations

These operations bring the backup files up-to-date with any changes to InnoDB tables that happened while the backup was in progress. Although for convenience you can combine this operation with the initial backup using the backup-and-apply-log command, you must run the steps separately when performing incremental backups.

mysqlbackup [STD-OPTIONS]
            [--limit-memory=MB] [--uncompress] [--backup-dir=PATH]
            [MESSAGE-LOGGING-OPTIONS]
            [PROGRESS-REPORT-OPTIONS]
            apply-log

mysqlbackup [STD-OPTIONS]
            [--incremental-backup-dir=PATH] [--backup-dir=PATH]
            [--limit-memory=MB] [--uncompress]
            [MESSAGE-LOGGING-OPTIONS]
            [PROGRESS-REPORT-OPTIONS]
            apply-incremental-backup

• apply-log

  Brings the InnoDB tables in the backup up-to-date, including any changes made to the data while the backup was running.

• apply-incremental-backup

  Brings the backup up-to-date using the data from an incremental backup.

Example 13.1 Apply Log to Full Backup

mysqlbackup --backup-dir=/path/to/backup apply-log

It reads the backup-my.cnf file inside backup-dir to understand the backup. The my.cnf defaults files have no effect other than supplying the limit-memory=MB value, which limits usage of memory while doing the apply-log operation.

Because the apply-log operation does not apply to incremental backups, no incremental-backup-dir is needed for this operation.

You can also perform apply-log and copy-back (which restores the prepared backup) together with a single copy-back-and-apply-log command.