Aside from having RAID-5 storage I want to make sure I have incremental, regular and automated backups in case anything goes wrong. I will always delete something I shouldn’t along the way, or run a command and mess up some data.
For the MySQL databases I run, the AutoMySQLBackup project looks to be the ticket.
My setup as follows:
- Mount a network share or create a folder for where to store the backups. I have chosen a separate storage array for the backups and mounted it with NFS.
- Download and install AutoMySQLBackup
- After running and testing the results, add a job to the daily, hourly or whatever suits ‘Crontab’ to execute the process without your intervention.
I now have a regular, automated backup of my MySQL databases running on my Ubuntu server.