mysql冷备份脚本

最新推荐文章于 2023-06-27 17:06:36 发布

不爱打酱油

最新推荐文章于 2023-06-27 17:06:36 发布

阅读量144

点赞数

文章标签： mysql linux bash

本文链接：https://blog.csdn.net/DAxingjiang007/article/details/129187413

版权

#!/bin/bash
#
#********************************************************************
#Author:            zhangwenbo
#QQ:                1765731173
#FileName:          backup_mysql.sh
#Description:       The test script
#********************************************************************

DATAPATH=/var/lib/mysql
TIME=`date +%F_%H-%M-%S`
BACKUP_SERVER=10.0.0.100
LOCK_FILE=/tmp/backup_mysql.lock
lock() {
    if [ -e ${LOCK_FILE} ] ;then
        echo "另一个备份正在执行，退出"
        exit
    else
        touch ${LOCK_FILE}
    fi
}

unlock (){
    if [ -e ${LOCK_FILE} ];then
        rm -f ${LOCK_FILE}
    fi
}

backup_mysql(){
    lock
    systemctl stop mysqld &>/dev/null
    tar zcf mysql-backup-${TIME}.tar.gz ${DATAPATH} &>/dev/null
    scp mysql-backup-${TIME}.tar.gz  ${BACKUP_SERVER}:/backup/  &>/dev/null
    systemctl start mysqld &>/dev/null
    unlock
}

backup_mysql