backup cron (backups of last 7 days, last month or any year)

gistfile1.txt

#!/bin/bash
#
# place this file in the directory you want to keep the backup
# mysqldumps. this script lets you retrieve dumps of last 7 days, 
# last month or any year
# 

BACKUP_DB=app_production
cd `dirname $0`
mysqldump $BACKUP_DB -u root > today.sql && \
  gzip -f today.sql && \
  cp today.sql.gz "`date +'%G'`".sql.gz && \
  cp today.sql.gz "`date +'%b'`".sql.gz && \
  cp today.sql.gz "`date +'%a'`".sql.gz