标题shell备份mysql 并删除15天前的数据
#!/bin/bash
#需要备份的数据库库名
db_name=mysql
bak_path=/tmp/sqlbak
[ ! -d $bak_path ] && mkdir -p $bak_path
mysqldump $db_name -p123 | gzip > $bak_path/$db_name$(date "+%F").sql.gz
if [ $? -eq 0 ];then
echo $(date "+%F") "$db_name数据库备份成功" >> $bak_path/mysql_bak.log
else
echo $(date "+%F") "$db_name数据库备份失败" >> $bak_path/mysql_bak.log
fi
rm -rf $(find $bak_path -name $db_name"*.sql.gz" -type f -mtime +15)