mysql备份脚本

db_user="root"
db_passwd="xxxx"
name="$(date +"%Y%m%d%H%M%S")"
days=1
orowner=oracle
bakdir=/home/backup
cd $bakdir
find $bakdir -type f -name "shoucan*.sql" -mmin +1380 -exec rm -f {} \;
/home/mysqldb/bin/mysqldump -u$db_user -p$db_passwd --add-drop-table --routines --triggers --events --master-data=2 --single-transaction --all-databases --force >/home/backup/shoucan$name.sql