Since I have been discussing scripting lately I thought I would continue with another topic I touched on briefly - backups.
I have written and modified the following script over the last few years. I have used it (and continue to use it) with multiple clients. It uses Percona's Xtrabackup to take the backup (although it can be easily modified to use mysqldump instead).
First the script
-----------------------------------------------------------------------------------------------------------------
#!/bin/bash
SAVEIFS=$IFS
IFS=$""
day_of_week=`date +%a`
backup_dir=/mysql-backup/
logfile=/root/backup_log.txt
report=/tmp/report.txt
servername=slave1
email=bmurphy@paragon-cs.com
password=`cat /root/.ssh/.backup_password`
# run backup
echo ' ' > $report
echo 'The backup is now beginning:' >> $report
echo ' ' …