Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- #备份目录
- #backup_home=/root/mysqlbackups
- #改成脚本所在目录 backup_home=$(dirname $0)
- backup_home=$(dirname $0)
- db_user=root
- db_pswd="1111"
- now=$(date +%Y-%m-%d)
- two_weeks_ago=$(date --date='2 weeks ago' +%Y-%m-%d)
- #dump current database¬
- mysqldump -u${db_user} -p${db_pswd} --all-databases | gzip -9 > ${backup_home}/mysql-${now}.sql.gz
- #删除两周前的备份,如果存在
- if [ -f ${backup_home}/mysql-${two_weeks_ago}.sql.gz ]; then
- rm ${backup_home}/mysql-${two_weeks_ago}.sql.gz
- fi
Add Comment
Please, Sign In to add comment