标签:
配置文件如下
##########BACKUPMYSQLCONFIG#######
#databasename
db_name=test
db_user=root
db_pass=123456
#####backupdayconfigbegin#####
day_backupdir=/home/backup/db/day
day_backup_fix=day
day_interval=1
#####backupdayconfigend#######
#####backupweekconfigbegin#####
week_backupdir=/home/backup/db/week
week_backup_fix=week
week_interval=2
#####backupweekconfigend#######
#####backupmonthconfigbegin#####
month_backupdir=/home/backup/db/month
month_backup_fix=month
month_interval=3
#####backupmonthconfigend#######
名称为: db_config
shell脚本如下:
#!/bin/bash
#Name:bak_ftp_day.sh
#ThisisaShellScriptForAutoFileBackupandDeleteoldBackup
#
#DIR变量为当前shell脚本的目录
DIR="$(cd"$(dirname"${BASH_SOURCE[0]}")"&&pwd)"
#使用source命令导入平级目录下的配置文件,引入以后就可以直接用配置中的变量名来获取文件中的值了
source$DIR"/"db_config
time=_`date+%Y_%m_%d_%H_%M_%S`_
echo"------bakup---<<>>---";
echo$day_backupdir/$db_name$time$day_backup_fix.sql.gz"---is--begin---";
mysqldump-u$db_user-p$db_pass$db_name|gzip>$day_backupdir/$db_name$time$day_backup_fix.sql.gz
echo$day_backupdir/$db_name$time$day_backup_fix.sql.gz"---is--finsh---";
find$day_backupdir-name$db_name"*.sql.gz"-typef-mmin+$day_interval-execrm-rf{}\;>/dev/null2>&1
echo"------bakup----<<>>---";
echo"";
标签: