#!/bin/bash

ROTATE_DAYS=7

MYSQL_DB=""
MYSQL_USER=""
MYSQL_PASSWORD=""

FILENAME="$MYSQL_DB-$(date +"%F").sql"
BACKUP_DIR="~/mysql_backup"

mysqldump -u $MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DB | gzip > $BACKUP_DIR/$FILENAME

# remove backups older than ROTATE_DAYS old
find $BACKUP_DIR -type f -name '*.sql' -mtime +$ROTATE_DAYS -exec rm {} \;