#!/bin/bash
DAY=30
DIR="/home/PATH/backups"
STAMP=$(date +"%Y-%m-%d_%H-%M-%S")

# Remove old files
echo "find ${DIR}/ -mtime +${DAY} -exec rm {} \;"
find ${DIR}/ -mtime +${DAY} -exec rm {} \;

# Backup new file
echo "mysqldump -h localhost -u USER -pPASS DATABASE > ${DIR}/${STAMP}_dump.sql"
mysqldump -h localhost -u USER -p'PASS' DATABASE > ${DIR}/${STAMP}_dump.sql