mysql 8.0 自动备份_运维之道 | MySQL8.0自动备份脚本

MySQL8.0自动备份脚本

1、在/data目录下创建一个shell目录，用于存放备份脚本

–创建目录

mkdir /data/shell

2、创建备份脚本

vim aotu_backup_mysql.sh

#!/bin/bash

#aoto bakcup mysql db

#by authors zwl 2019

#define backup path

BAK_DIR=/data/backup/`date +%Y%m%d`

MYSQLDB=zwl

MYSQLUSR=backup

MYSQLPW=123456

MYSQLCDM=/usr/bin/mysqldump

if [ $UID -ne 0 ];then

echo "Must to be use root for exec shell."

fi

if [ ! -d $BAK_DIR ];then

mkdir -p $BAK_DIR

echo -e "\033[32mTHE $BAK_DIR Create successfully!\033[0m"

else

echo "This $BAK_DIR is exists... "

fi

######################## Mysql Backup command

$MYSQLCMD -u$MYSQLUSR -p$MYSQLPW -d$MYSQLDB > $BAK_DIR/$MYSQLDB.sql

if [ $? -eq 0 ];then

echo -e "\033mT