非常重要的mysql數(shù)據(jù)庫定時備份！第一步.創(chuàng)建腳本文件夾第二步.創(chuàng)建shell腳本第三步.添加定時任務效果：

發(fā)布時間：2023-07-03 14:04:33 作者：網友整理

數(shù)據(jù)是非常重要的，所以數(shù)據(jù)備份必不可少！比如受到攻擊，或者人為誤操作時，備份數(shù)據(jù)就派上用場，及時恢復數(shù)據(jù)，將影響降到最低。下面以MySQL為例，利用mysqldump(mysql自帶工具)工具進行備份，實現(xiàn)每天整點定時備份數(shù)據(jù)庫（定時是利用linux的crontab，可以自己配置任意時間），并且只保留7天(時間可配置)

假設數(shù)據(jù)庫名為：test

第一步.創(chuàng)建腳本文件夾

mkdir /usr/local/mysql_backup/dump;

第二步.創(chuàng)建shell腳本

(1)cd mkdir /usr/local/mysql_backup;

(2)vim mysql_backup.sh

內容如下(備份數(shù)據(jù)庫test)：

#!/bin/bash
# 設置mysql登錄用戶名和密碼
mysql_user=""
mysql_password=""
mysql_host=""
mysql_port=""
mysql_charset="utf8mb4"
# 備份存放地址
backup_location=/usr/local/mysql_backup/dump
log_location=/usr/local/mysql_backup/log.log
# 是否刪除過期數(shù)據(jù)
expire_backup_delete="ON"
expire_days=7
backup_time=`date +%Y-%m-%d_%H%M`
backup_dir=$backup_location
welcome_msg="===============into MySQL backup sh================"
# 判斷mysql實例是否正常運行
mysql_ps=`ps -ef |grep mysql |wc -l`
mysql_listen=`netstat -an |grep LISTEN |grep $mysql_port|wc -l`
if [ [$mysql_ps == 0] -o [$mysql_listen == 0] ]; then
        echo $(date "+%Y-%m-%d %H:%M:%S") "ERROR:MySQL is not running! backup stop!">> $log_location
        exit
else
        echo $(date "+%Y-%m-%d %H:%M:%S") $welcome_msg>> $log_location
fi
# 備份指定數(shù)據(jù)庫中數(shù)據(jù)
echo $(date "+%Y-%m-%d %H:%M:%S") "begin dump db test">> $log_location
mysqldump -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -B test> $backup_dir/test_$backup_time.sql
flag=`echo $?`
if [ $flag == "0" ];then
        echo $(date "+%Y-%m-%d %H:%M:%S") "database test success backup">> $log_location
else
        echo $(date "+%Y-%m-%d %H:%M:%S") "database test backup fail!">> $log_location
fi
# 刪除過期數(shù)據(jù)
if [ "$expire_backup_delete" == "ON" -a  "$backup_location" != "" ];then
        `find $backup_location/ -type f -mtime +$expire_days | xargs rm -rf`
        echo $(date "+%Y-%m-%d %H:%M:%S") "Expired backup data delete complete!">> $log_location
fi