shell 备份数据库

# 配置mysql备份
* * * * * sh /home/cron/back_mysql_db.sh >> /tmp/back_mysql_db.log 2>&1

#!/bin/bash

# 没有则创建
if [ ! -d "/home/wwwroot/default/mysqlbackup" ];then
        mkdir -p "/home/wwwroot/default/mysqlbackup"
fi

# 备份数据库
mysqldump -uroot -p****** admin_v3 > /home/wwwroot/default/mysqlbackup/admin_v3_$(date "+%Y%m%d%H%M%S").sql

# 20分钟前的删除
find /home/wwwroot/default/mysqlbackup/ -type f -mmin +20 -exec rm -rf {} \;