pagoda cron commands for regular MySQL backups

mysql_backup.sh

# 'backups/' dir must exist previously.

# Removes backup files older than 7 days, 
Command: find backups/* -mtime +7 -exec rm {} \;
# Every day at midnight
UNIX cron schedule: 0 0 * * *

# Creates backups in the 'backups/' writable directory.
Command: mysqldump -h $DB1_HOST -P $DB1_PORT -u $DB1_USER -p$DB1_PASS $DB1_NAME > backups/$DB1_NAME-"$(date +"%m_%d_%Y")".sql
# Every day at 1AM
UNIX cron schedule: 0 1 * * *