#备份数据库,并删除七日之前的备份,即只保留七日之内的备份数据。
#!/bin/bash
#author: lijg
#date: 20170113
db_user="usr"
db_pwd="pwd"
for db in "db1" "db2"
do
db_backup_path="/backup/path/${db}"
mysqldump -u ${db_user} -p${db_pwd} ${db} | gzip > "${db_backup_path}/${db}.`date -d "now" +%Y%m%d`.sql.gz"
cd ${db_backup_path} && set -f rm "${db}.`date -d "-7 days" +%Y%m%d`.sql.gz"
done
001.Shell脚本数据库备份
最新推荐文章于 2022-02-28 18:05:33 发布