centos7 xtrabackup mysql（8）增量备份 脚本（2）

centos7 xtrabackup mysql（8）增量备份 脚本（2）

Shell 基本运算符
https://www.runoob.com/linux/linux-shell-basic-operators.html

https://blog.youkuaiyun.com/weixin_30823001/article/details/96417008

https://blog.youkuaiyun.com/weixin_35985795/article/details/113379060

https://blog.youkuaiyun.com/qq_42768234/article/details/133277583

测试用脚本

cat script_xtrabackup.sh

#!/bin/sh
. /etc/profile
user=root
password=1234aA~1
backup_dir=/data/
gzip_dir=$backup_dir
log_dir=$backup_dir/log

# 全备是在一周的第几天
full_backup_week_day=1
error_log=

# 备份日期

backup_date=`date +%Y%m%d`


# 备份时间

backup_time=`date +%H-%M-%S`

# 备份时的周几

backup_week_day=`date +%u`

mkdir -p $backup_dir

mkdir -p $log_dir


log_file=${
   backup_dir}/log/backup.log
log_x_file=${
   backup_dir}/log/backup_xtra.log


x_file_size=`ls -l $log_x_file | awk '{print $5}'`

num_x_file_size=$((x_file_size))
echo $num_x_file_size

if [ $num_x_file_size -gt 9000000 ];then
    echo "" > $log_x_file
fi


echo $backup_date
echo $backup_time
echo $backup_week_day

let delta=backup_week_day-full_backup_week_day

echo $delta
echo ""
echo ""
echo '------------------  start  ---------------------'${
   backup_date} ${
   backup_time} >> $log_file

if [ "$delta" -eq 0 ]
then
    # 全量备份
    echo '全量备份 delta=$delta' >> ${
   log_file}

    mkdir -p $backup_dir/backup$backup_date

    if [ -e "$backup_dir/backup$backup_date/full_backup"