Documentation Home
MySQL Enterprise Backup 3.12 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb

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]

mysqlbackup [STD-OPTIONS]
            [--incremental-backup-dir=PATH] [--backup-dir=PATH]
            [--limit-memory=MB] [--uncompress]
  • 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.