Mysql incremental Backup

Question

Hello Everyone,

Can anyone help me to take incremental backup in mysql.

i had some idea about that but it is not cleared in my mind ,

please give solutions in steps

Thanks in advance!!!

Riddhi

Answer 1

Check the MySQL :: MySQL 5.1 Reference Manual :: 6.2 Database Backup Methods page and read the "Making Incremental Backups by Enabling the Binary Log" section. We can't put it clearer than that :)

Another option is to use MySQLDump, and diff the new dumpfile version an old(er) one, then only store the diff. See the implementation example at MySQLDump comment section.