With Ubuntu a sysadmin John can get up a MySQL server with a simple command :
apt-get install mysql
The developer Mark who will use this instance happy be glad to have it available so fast.
But tragedy lies behind the door: Mark request to John to restore a copy of yesterday database, but John say to Mark: "You have not made a copy of your database?" reply Mark :"No! You are the sysadmin and you have to do a backup of databases".
Mark assume that the John create a periodical backup of all databases in that instance.
In this case for John there is a simple tool: AutoMySQLBackup.
Install this tool is very simple:
apt-get install automysqlbackup
This is a script to take daily, weekly and monthly backups of your MySQL databases using mysqldump.
The backup files will be placed in /var/lib/automysqlbackup which you should rsync somewhere off-site
John can sleep safe now. :)
