Incremental backup, recovery

from the Artful MySQL Tips List


Mysqldump doesn't support date-filtered or incremental backups.

See https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html and http://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html for how to do incremental recovery from the Binary Log.

See https://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/incremental_backups.html for how to do incremental backups with xtrabackup and innobackupex.

Last updated 30 Jun 2020


Return to the Artful MySQL Tips page