A nice bash script from SourceForge to take daily, weekly and monthly backups of your MySQL databases.
– Backup mutiple databases
- Single backup file or to a seperate file for each DB
- Compress backup files
- Backup remote servers
– E-mail logs to you
Here are the steps to run this script on your VPS/Dedicated server: