Documentation Home
MySQL Enterprise Backup 3.12 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb
HTML Download (TGZ) - 173.3Kb
HTML Download (Zip) - 198.8Kb


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 default 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.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.