centos7 xtrabackup mysql(8)增量备份 脚本(2)
Shell 基本运算符
https://www.runoob.com/linux/linux-shell-basic-operators.html
https://blog.csdn.net/weixin_30823001/article/details/96417008
https://blog.csdn.net/weixin_35985795/article/details/113379060
测试用脚本
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_dirmkdir -p $log_dirlog_file=${backup_dir}/log/backup.log
log_x_file=${backup_dir}/log/backup_xtra.logx_file_size=`ls -l $log_x_file | awk '{print $5}'`num_x_file_size=$((x_file_size))
echo $num_x_file_sizeif [ $num_x_file_size -gt 9000000 ];thenecho "" > $log_x_file
fiecho $backup_date
echo $backup_time
echo $backup_week_daylet delta=backup_week_day-full_backup_week_dayecho $delta
echo ""
echo ""
echo '------------------ start ---------------------'${backup_date} ${backup_time} >> $log_fileif [ "$delta" -eq 0 ]
then# 全量备份echo '全量备份 delta=$delta' >> ${log_file}mkdir -p $backup_dir/backup$backup_dateif [ -e "$backup_dir/backup$backup_date/full_backup" ];thenecho "full_backup exist " >> ${log_file}exit 0fixtrabackup --backup --target-dir=$backup_dir/backup$backup_date/full_backup --user=$user --password=$password --socket=/opt/datadir/mysql/mysql.sock >> ${log_x_file} 2>&1elif [ "$delta" -eq 1 ]
thenecho "" >> ${log_file}echo "" >> ${log_file}echo "第一次增量备份 delta=$delta" >> ${log_file}date_last=$(date -d "-1 day" '+%Y%m%d')echo $date_last >> ${log_file}if [ -e "$backup_dir/backup${date_last}/inc_1_backup" ];thenecho "inc_1_backup exist " >> ${log_file}exit 0fiif [ ! -e "$backup_dir/backup${date_last}/full_backup" ];thenecho "full_backup not exist " >> ${log_file}exit 0fixtrabackup --backup --target-dir=$backup_dir/backup${date_last}/inc_1_backup --incremental-basedir=$backup_dir/backup${date_last}/full_backup --user=root --password=1234aA~1 --socket=/opt/datadir/mysql/mysql.sock >> ${log_x_file} 2>&1elif [ "$delta" -gt 0 ]
thenecho "" >> ${log_file}echo "" >> ${log_file}echo "delta大于0 增量备份 delta=$delta" >> ${log_file}date_last=$(date -d "-${delta} day" '+%Y%m%d')echo $date_last >> ${log_file}if [ -e "$backup_dir/backup${date_last}/inc_${delta}_backup" ];thenecho "inc_${delta}_backup exist " >> ${log_file}exit 0fiif [ ! -e "$backup_dir/backup${date_last}/inc_$((delta-1))_backup" ];thenecho "$backup_dir/backup${date_last}/inc_$((delta-1))_backup"echo "inc_$((delta-1))_backup not exist " >> ${log_file}exit 0fixtrabackup --backup --target-dir=$backup_dir/backup${date_last}/inc_${delta}_backup --incremental-basedir=$backup_dir/backup${date_last}/inc_$((delta-1))_backup --user=root --password=1234aA~1 --socket=/opt/datadir/mysql/mysql.sock >> ${log_x_file} 2>&1
elseecho "" >> ${log_file}echo "" >> ${log_file}echo "delta小于0 增量备份 delta=$delta" >> ${log_file}let num=7+$deltaecho 'num ='${num} >> ${log_file}date_last=$(date -d "-${num} day" '+%Y%m%d')echo $date_last >> ${log_file}echo $((num-1)) >> ${log_file}if [ -e "$backup_dir/backup${date_last}/inc_${num}_backup" ];thenecho "inc_${num}_backup exist " >> ${log_file}exit 0fiif [ ! -e "$backup_dir/backup${date_last}/inc_$((num-1))_backup" ];thenecho "inc_$((num-1))_backup not exist " >> ${log_file}exit 0fixtrabackup --backup --target-dir=$backup_dir/backup${date_last}/inc_${num}_backup --incremental-basedir=$backup_dir/backup${date_last}/inc_$((num-1))_backup --user=root --password=1234aA~1 --socket=/opt/datadir/mysql/mysql.sock >> ${log_x_file} 2>&1
fi#sudo xtrabackup --backup --target-dir=/data//backup20240729/inc_3_backup --incremental-basedir=/data//backup20240729/inc_1_backup --user=root --password=1234aA~1 --socket=/opt/datadir/mysql/mysql.sock
恢复提示语句 脚本
cat create_restore_file.sh
#!/bin/shmysql_dir=/opt/datadir/
backup_dir=/data/date2="20080203"
date_store=`date -d "$date2" +%s`
echo $date_store
file_store=''
for file in $backup_dir/*
doecho $fileif [ -d "$file" ];thenecho "$file is a dir"dir_name=${file##*/}echo "file name = $dir_name"if [[ $dir_name == backup* ]];thenecho "dir_name= $dir_name"substring=${dir_name:6:8}echo "substring=$substring"date1=`date -d "$substring" +%s`echo "$date1"if [ $date_store -lt $date1 ];thendate_store=$date1echo "hello $date_store"file_store=$fileecho "$file_store"fififi
donenum='0'
for file in $file_store/*
doecho $fileif [ -d "$file" ];thendir_name=${file##*/}echo "file name = $dir_name"if [[ $dir_name == inc* ]];thenecho "dir_name= $dir_name"substring=${dir_name:4:1}echo "substring=$substring"if [ $num -lt $substring ];thennum=$substringfififi
doneecho "num= $num"
echo "sudo systemctl stop mysqld" > ~/restore_sql.txt
echo "sudo cp -r ${mysql_dir}/mysql ${mysql_dir}/bak_mysql" >> ~/restore_sql.txt
echo "sudo rm -rf ${mysql_dir}/mysql/*" >> ~/restore_sql.txtecho "sudo xtrabackup --prepare --apply-log-only --target-dir=$file_store/full_backup" >> ~/restore_sql.txtcnt=$((num))
echo "cnt = $cnt"
if [ $num -gt '0' ];thenfor((i=1;i<$cnt;i++));doecho "xtrabackup --prepare --apply-log-only --target-dir=$file_store/full_backup --incremental-dir=$file_store/inc_${i}_backup" >> ~/restore_sql.txtdoneecho "xtrabackup --prepare --target-dir=$file_store/full_backup --incremental-dir=$file_store/inc_${cnt}_backup" >> ~/restore_sql.txtfiecho "sudo xtrabackup --copy-back --target-dir=$file_store/full_backup" >> ~/restore_sql.txtecho "sudo chown -R mysql.mysql ${mysql_dir}/mysql/*" >> ~/restore_sql.txtecho "sudo systemctl restart mysqld" >> ~/restore_sql.txt