#!/bin/sh
###定义变量####
date=`date +%Y%m%d`
ago10date=`date -d"10 day ago" +"%Y%m%d"`
backuser=username
db_host=localhost
backupdir=/home/www/dbback
###判断存放目录是否存在####
if [ ! -d $backupdir ]
then
mkdir -p $backupdir
fi
###判断第二级存放目录是否存在####
if [ ! -d $backupdir/$date ]
then
mkdir -p $backupdir/$date
fi
##########执行备份命令#############
/usr/bin/mysqldump -u$backuser -h $db_host -ppassword --single-transaction hc > "$backupdir/$date/hc.sql"
##########删除10天前的备份#########
if [ -d $backupdir/$ago10date ]
then
rm -rf $backupdir/$ago10date
fi