Loading...

Performing a Block-Level Incremental Backup for MySQL Databases

When you perform a block-level incremental backup, only the blocks on the disk that have changed since the last full or incremental backup are backed up. This results in faster backups that consume less media and other resources.

Note: If you do any of the following, then the next block-level backup is automatically converted to a full backup, even when you select a block-level incremental backup.

  • Select a different snap engine for taking snapshots.
  • Change the device configuration between jobs, such as changing the extent size.
  • Change the storage policy that is associated with the subclient that you have configured for performing a block-level backup.

Procedure

  1. From the CommCell Browser, expand Client Computers > Client > MySQL > Instance.
  2. Right-click the subclient that you have configured for performing a block-level backup, and click Backup.
  3. In the Backup Options dialog box, select Incremental as the backup type.
  4. Optional: To back up data along with the logs, select the Data check box.
  5. In the Job Initiation section, choose whether to run the backup job immediately or schedule it.
  6. Click OK.

Result

The Job Controller displays the incremental backup job as Snap Backup.

After the incremental backup job is complete, another incremental backup job starts automatically to back up the binary logs. However, if you disable binary logging from the MySQL Server, the automatic incremental job does not run.

You can view detailed information about a backup job, such as the objects that were backed up or the backup option that was used. For more information, see View Details of a Block-Level Backup Job.