MySQL backup retains one months of data files

#!/bin/sh
# File:/data/backup/dhdatabak.sh
# Write By:sandy
# Last Modify:2013-09-11
# Database Info
Db_name= "Osite"
Db_user= "USER"
db_pass= "PWD"

# Others VARs
Bck_dir= "/data/backup/dhdata"
Date= ' Date ' +%y%m%d-%h_%m "'
Days=30
Logfile=/data/backup/logs/dhbackup.log

# TODO
Mysqldump-r--opt-u$db_user-p$db_pass $DB _name > $BCK _dir/dh_$date.sql
echo "$date Database: $databases backup Success!" >> $LOGFILE
CD $BCK _dir
TAR-ZCVF dh$date.tar.gz Dh_$date.sql

RM $BCK _dir/dh_$date.sql

Find $BCK _dir-name "dh*"-type f-mtime + $DAYS-exec rm {} \;

1 * * * root/data/backup/dhdatabak.sh >>/data/backup/logs/cronlog.txt 2>&1

This article is from the "Huangyi blog" blog, please be sure to keep this source http://linuxpython.blog.51cto.com/10015972/1653085

MySQL backup retains one months of data files