08/08/14

MySQL automatic backup

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. :)