Re: Mysql real time backup tool for mysql for linux server

[Barry Galbraith]

I use mysqldump, which is a client program that comes with MySQL to take a full backup, and I have binary logging running to log changes as they happen.
When I take a full backup, mysqldump writes the binary log file info to the backup file, so that if I need to restore, I can load the backup, and thren the binary log from the position noted in the backup to restore the database to ":now".
mysqldump is run as a cron job as often as you want it to run.
Mine runs once a week, and rotate the binary log when I take a backup.

See the refman.
http://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html

Good luck,
Barry.