gistfile1.sh

#!/usr/bin/env bash

DUMP_DIR="/var/www/dumps"
cur_date=`date +%Y.%m.%d`
file=$(printf "dump.%s.sql" "$cur_date")
archive=$(printf "%s.gz" "$file")
mysqldump --host=%% --user=%% --password=%% % > $DUMP_DIR/$file
gzip -cf $DUMP_DIR/$file > $DUMP_DIR/$archive
rm $DUMP_DIR/$file

old_date=`date +%Y.%m.%d -d "10 days ago"`
old_file=$(printf "dump.%s.sql.gz" "$old_date")
rm $DUMP_DIR/$old_file