#1 Difference between Automysqlbackup and this.

[Timmy]

Hello,
Automysqlbackup also has a built-in differential dump function. What is the difference between yours and theirs?
https://sourceforge.net/p/automysqlbackup/support-requests/33/

[nima0102]

Hi
Thanks for your atention. About differential dump, it is not functional way to do an incremental backup. because it just makes a diff between whole dump files, like diff between 2 simple files.It does not work and for a real production serves. because there are many text and other info that maybe be included in that diff file and also it is not possible to get a diff on big files. you are working with queries not simple text. So I had to write this script to do incremental backup or hourly backup. My approache is, taking whole backup by automysqlbackup and use it as a base point to start doing hourly backup/incremental by using binary logs without any effect on database from the previous binlog position that whole backup has been done. I think it is a accurate method to do incremental backup on Mysql. I wrote an article about that you can find it on:

https://www.howtoforge.com/tutorial/mysql-incremental-backup-point-in-time-recovery/