SHELL指令碼自動備份資料庫

標籤：date   格式   mysql   shell指令碼   db_name   back   direct   seve   echo   

#!/bin/bashdb_user="root"db_passwd="dddddd "db_name="mmmmmm"cd /db_backupecho "you are in bakmysql directory now"backup_dir="/db_backup"#時間格式time=$(date+ "%Y+%m+%d")#mysql備份命令mysqldump -u$db_user -p$db_passwd $db_name > "$backup_dir/$db_name"-"$time.dump"echo "your database backup successfully completed"#刪除7天前的備份檔案SevenDays=$(date -d -7days +"%Y%m%d")if [ -f /db_backup/ebkcmp-$SevenDays.dump]thenrm -rf /db_backup/ebkcmp-$SevenDays.dumpecho "you have delete the sql file"elseecho "the sql file not exits"echo "bash completed"fi

　　

SHELL指令碼自動備份資料庫