Incremental MySQL backup to Amazon S3

Looking at this now. 开发者_JAVA技巧Any script recommendation will do. Using Rails app too.

The difference with current scripts around is it's a full backup, my MySQL database files are like 120MB+ for now, which will increase overtime. So I wonder if there is any incremental method around.

This recent thread on mysql.com discusses it.

Basically, you have to set the server up to do binary logging and set a threshold for each log to whatever size increment you prefer for backing up. Then just upload a complete backup once and start your binary logging from that point forward. Then just upload each log once it is closed and a new one is opened.

It is more complicated than that but I think that should get you started.