linux服务器的数据库自动备份脚本

￡神魔★判官ぃ 2022-05-31 06:23 289阅读 0赞

脚本文件下载：[http://download.csdn.net/download/chen\_gp\_x/10247413][http_download.csdn.net_download_chen_gp_x_10247413]

如果需要请联系QQ：154158462

修改相应的参数，将文件传到linux服务器，使用 crontab -e 命令，添加定时任务（每两个小时执行一次）0 \*/2 \* \* \* /root/dbbackup

crontab -e
    0 */2 * * * /root/dbbackup
    
    crontab的详细使用说明请自行百度，/root/dbbackup为存放.sh脚本文件的路径

注意：记得要设置文件和文件的可执行权利（777）.

#!/bin/bash
    #Author 154158462@qq.com
    MAXIMUM_BACKUP_FILES=100                #最大备份文件数
    BACKUP_FOLDERNAME="/root"               #数据库备份文件的主目录
    DB_HOSTNAME="localhost"                 #mysql所在主机的主机名
    DB_USERNAME="root"                      #mysql登录用户名
    DB_PASSWORD="mysqlPassword"             #mysql登录密码
    DATABASES=(
    "mysql"
    "information_schema"
    "performance_schema"
    "zb_rent"                 #备份的数据库名,需要备份的都可以写在这
    )
    #=========
    echo "Bash Database Backup Tool"
    #CURRENT_DATE=$(date +%F_%T)
    CURRENT_DATE=$(date +%F_%H-%M-%S)              #定义当前日期为变量(%T)xp系统命名不能使用：
    BACKUP_FOLDER="${BACKUP_FOLDERNAME}_${CURRENT_DATE}" #存放数据库备份文件的目录
    mkdir $BACKUP_FOLDER #创建数据库备份文件目录
    #统计需要被备份的数据库
    count=0
    while [ "x${DATABASES[count]}" != "x" ];do
    count=$(( count + 1 ))
    done
    echo "[+] ${count} databases will be backuped..."
    #循环这个数据库名称列表然后逐个备份这些数据库
    for DATABASE in ${DATABASES[@]};do
    echo "[+] Mysql-Dumping: ${DATABASE}"
    echo -n "   Began:  ";echo $(date)
    if $(/usr/local/mysql/bin/mysqldump -h ${DB_HOSTNAME} -u${DB_USERNAME} -p${DB_PASSWORD} ${DATABASE} > "${BACKUP_FOLDER}/${DATABASE}.sql");then
    echo "  Dumped successfully!"
    else
    echo "  Failed dumping this database!"
    fi
    echo -n "   Finished: ";echo $(date)
    done
    echo
    echo "[+] Packaging and compressing the backup folder..."
    tar -cv ${BACKUP_FOLDER} | bzip2 > ${BACKUP_FOLDER}.tar.bz2 && rm -rf $BACKUP_FOLDER
    BACKUP_FILES_MADE=$(ls -l ${BACKUP_FOLDERNAME}*.tar.bz2 | wc -l)
    BACKUP_FILES_MADE=$(( $BACKUP_FILES_MADE - 0 ))
    #把已经完成的备份文件数的结果转换成整数数字
    
    echo
    echo "[+] There are ${BACKUP_FILES_MADE} backup files actually."
    #判断如果已经完成的备份文件数比最大备份文件数要大，那么用已经备份的文件数减去最大备份文件数,打印要删除旧的备份文件
    if [ $BACKUP_FILES_MADE -gt $MAXIMUM_BACKUP_FILES ];then
    REMOVE_FILES=$(( $BACKUP_FILES_MADE - $MAXIMUM_BACKUP_FILES ))
    echo "[+] Remove ${REMOVE_FILES} old backup files."
    #统计所有备份文件，把最新备份的文件存放在一个临时文件里，然后删除旧的文件，循环出临时文件的备份文件从临时目录里移到当前目录
    ALL_BACKUP_FILES=($(ls -t ${BACKUP_FOLDERNAME}*.tar.bz2))
    SAFE_BACKUP_FILES=("${ALL_BACKUP_FILES[@]:0:${MAXIMUM_BACKUP_FILES}}")
    echo "[+] Safeting the newest backup files and removing old files..."
    FOLDER_SAFETY="_safety"
    if [ ! -d $FOLDER_SAFETY ]
    then mkdir $FOLDER_SAFETY
    
    fi
    for FILE in ${SAFE_BACKUP_FILES[@]};do
    
    mv -i  ${FILE}  ${FOLDER_SAFETY}
    done
    rm -rf ${BACKUP_FOLDERNAME}*.tar.bz2
    mv  -i ${FOLDER_SAFETY}/* ./
    rm -rf ${FOLDER_SAFETY}

**如果需要请查看下篇：使用windows电脑将服务器备份文件自动批量下载到本地主机上。**

**        转载请注明出处****：[http://blog.csdn.net/chen\_gp\_x][http_blog.csdn.net_chen_gp_x]**

[http_download.csdn.net_download_chen_gp_x_10247413]: http://download.csdn.net/download/chen_gp_x/10247413
[http_blog.csdn.net_chen_gp_x]: http://blog.csdn.net/chen_gp_x