Simple MySQL backup tool in Linux
I’ve found automysqlbackup as the simplest MySQL DB backup tool. Its so simple that you dont have to do anything after install. Just apt-get it and forget, it will backup your DB’s daily, weekly and monthly! Its worth to try it; personally I would rate this 10/10.
Steps for Debian based OS
Step1. apt-get install automysqlbackup
Step2: run as root “automysqlbackup”
After running the above command, it creates dir’s under /var/lib/automysqlbackup by the names of your DB’s. Under each DB dir you’ll find “daily”, “weekly” and “monthly” dirs. As the name itself suggests that it stores daily, weekly and monthly backups of the respective DB’s.