線上MySQL備份指令碼

線上MySQL備份指令碼

最近在研究Database Backup，定時執行備份任務，這裡直接把備份指令碼設定為crontab命令定時執行，指令碼內容如下:
[root@mysql-db ~]# cat mysql-backup.sh
#!/bin/bash
dbpwd='possw0rd123'
dbuser=root
host=127.0.0.1
port=3306
dbarg=" -u$dbuser -p$dbpwd -h$host -P$port --default-character=utf8 "
DATE=`date +%Y%m%d`
BAK_PATH=/DBBackup/backup/DB_Bak
LOG=$BAK_PATH/$DATE/backup.log
keep_backup_days=7

mkdir -p $BAK_PATH/$DATE/$port

for db in `echo show databases|mysql $dbarg|grep -v "information_schema\|test\|mysql\|Database" `
do
    echo -e "$DATE `date +%T` DUMP $port $db  .. \c " >>$LOG
    mysqldump -B $dbarg -R $db |gzip >$BAK_PATH/$DATE/$port/${db}_${port}.sql.gz
    echo -e "`date +%T` OK " >>$LOG
done

for dir in `ls $BAK_PATH|grep [0-9]$`
do
    if [ `ls -l $BAK_PATH|grep [0-9]$|wc -l` -gt 2 ];then
        find ${BAK_PATH}/$dir -name "*.sql.gz*"  -ctime +${keep_backup_days}|xargs rm -f
        find ${BAK_PATH}/$dir -name backup.log  -ctime +${keep_backup_days}|xargs rm -f
        find ${BAK_PATH}/$dir -type d -empty |xargs rm -rf
#清除空目錄
        find ${BAK_PATH}/$dir -type d -empty |xargs rm -rf
    fi
done

1 4 * * * sh /DB-Backup/shell/DB_backup.sh

本文永久更新連結地址：