simple backup script

backup.sh

dbname="mydb"
user="user"
pass="pass"
scriptpath="/home/sqlbackup"
logfile="$scriptpath/backup.log"
timestamp=`/bin/date +%Y%m%d-%H%M`
# number of days to keep the backups
keepfordays=14

mysqldump -u $user -h localhost -p$pass $dbname | gzip -9 > $scriptpath/backups/$dbname-$timestamp.sql.gz
echo "$timestamp created new backup $dbname-$timestamp.sql.gz" >> $logfile

for file in "$( /usr/bin/find $scriptpath/backups -type f -mtime +$keepfordays )"
do
  /bin/rm -f $file
  echo "$timestamp deleted $file" >> $logfile
done