1. Database backup bash script
2. Perl email script
3. Cron job configuration to run the script
Here are some scripts that will help you make a database backup and than
another script that will send you an email, to confirm that the backup was made and probably if you want you can make the script send you the backup attached via email…
Then finally a cron configuration to run the database backup script everyday, week, month or once a year.
So here is the step by step tutorial…
First Lets make some directories..
1. Make a directory in /var/backups/ called sqlbackup