Mysql – Incremental/Differential MySQL Backup using thesqldump

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