sh脚本:
backupdir=/data/mysql_backup
time=date +%Y_%m_%d_%H_%M_%S
db_host=10.168.66.19
db_user=dealerqa
db_pass=dealerqa123
mysqldump --host=$db_host -u
d
b
u
s
e
r
−
p
db_user -p
dbuser−pdb_pass --databases dealertest >
b
a
c
k
u
p
d
i
r
/
backupdir/
backupdir/time.sql
find $backupdir -name “*.sql” -type f -mtime +7 -exec rm -rf {} ; > /dev/null 2>&1