Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
Mysql – Incremental/Differential MySQL Backup using thesqldump
database-backupMySQL
database-backupMySQL
Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
Best Answer
You can simulate incremental backup by enabling and then backing up the binary logs. See http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html under "Making Incremental Backups by Enabling the Binary Log."