Compatibility Matrix
The following table below outlines the various tools for backing up MySQL database, along with their respective supported features and options.
Database Engine
Tool
Supported OS
Operation
All Databases
Specific Database
Specific Table
MySQL (8.4 LTS, 8.0 LTS)
Xtrabackup
Linux
Backup
Full backup, Incremental backup(Chained Differential)
Full backup only
Full backup only
Recovery
Full Recovery, Incremental Recovery, PITR
Full Recovery
Full recovery only
Mydumper
Linux
Backup
Full backup, Incremental backup(Chained Differential)
Full backup, Incremental backup(Chained Differential)
Full backup only
Recovery
Full Recovery, Incremental Recovery, PITR
Full Recovery, Incremental Recovery, PITR
Full recovery only
Mysqldump
Windows & Linux
Backup
Full backup, Incremental backup(Chained Differential)
Full backup, Incremental backup(Chained Differential)
Full backup only
Recovery
Full Recovery, Incremental Recovery, PITR
Full Recovery, Incremental Recovery, PITR
Full recovery only
LVM
Linux
Backup
Full backup
NA
NA
Recovery
Full Recovery
NA
NA
Backup types-
Full Backup: A complete copy of all data from the selected databases will be taken.
Incremental Backup: Only the data that has changed since the last backup will be captured.
During the backup the dedupe will be enforced only changed data will be backed up.
Recovery types-
Full Recovery: Restores all data from the full backup snapshot, returning the database to its exact state at the time of the full backup.
Incremental Recovery: Restores all data from the full backup, plus all incremental backups taken up to the selected incremental backup, bringing the database up to date as of the selected incremental backup.
Point-in-Time Recovery (PITR): Restores all data from the full backup, plus all incremental backups taken up to a specific timestamp, allowing you to recover the database to a precise point in time.
Last updated
Was this helpful?