#!/bin/bash
# Name:bak_xx_mysql.sh
# XX数据库文件备份
#
db_user="root"
db_passwd="root"
db_name="db_name"
#mysqldump 目录
mysql_bin_dir="/alidata/server/mysql-5.6.21/bin/mysqldump"
# 备份文件目录
backup_dir="/alidata/www/tequ_mysql_bak"
# 按照时间格式命名
time="$(date +"%Y%m%d%H%M%S")"

$mysql_bin_dir -u$db_user -p$db_passwd $db_name > $backup_dir"/"$db_name"_"$time".sql"

#删除10天前的备份
find $backupdir -name "db_name*.sql" -type f -mtime +10 -exec rm {} \; > /dev/null 2>&1