mariabackup实现mariadb数据库的自动备份

1、先进行一次全量备份：
mariabackup -uroot -pmypassword --backup --target-dir=/backup/base

2、进行一次昨天的增量备份：
mariabackup -uroot -pmypassword --backup --target-dir=/backup/20221205 --incremental-basedir=/backup/base

3、进行一次今天的增量备份：
mariabackup -uroot -pmypassword --backup --target-dir=/backup/20221206 --incremental-basedir=/backup/20221205

4、/root目录下编辑自动备份脚本：
vim /root/sydwMariadbBackup.sh
输入以下内容：

#!/bin/bash
the_day_before_increase_folder=/backup/$(date -d '1 days ago' +'%Y%m%d%H%M%S')
increase_folder=/backup/$(date +'%Y%m%d%H%M%S')
mariabackup -uroot -pmypassword --backup --target-dir=$increase_folder --incremental-basedir=$the_day_before_increase_folder

或者：
#!/bin/bash
backup_folder=/backup
previous_folder=predata
current_folder=curdata
history_folder=$(date -d '120 minute ago' +'%Y%m%d%H%M')
cd $backup_folder
mariabackup -uroot -pmypassword --backup --target-dir=/backup/$current_folder --incremental-basedir=/backup/$previous_folder
mv $previous_folder $history_folder
mv $current_folder $previous_folder
#tar -zcvf $history_folder.tar.gz $history_folder



保存
chmod 775 /root/sydwMariadbBackup.sh

5、添加linux定时任务：
crontab -e
添加一行：
10 1 * * * sh /root/sydwMariadbBackup.sh 2>&1 > /root/mariadbBackup/log_$(date +\%Y-\%m-\%d)

systemctl start crond


数据还原：
备份文件复制到目标服务器后
mariabackup --prepare --target-dir=/data/backup/base

mariabackup --prepare --target-dir=/data/backup/base --incremental-dir=/data/backup/20221205

自动执行：
#!/bin/bash
base_folder=/data/basics/base
for file in /data/backup/*
do
if [ -d "$file" ] && [ "$file" != "/data/backup/predata" ] && [ "$file" != "/data/backup/curdata" ]
then
# echo "$file"
mariabackup --prepare --target-dir=$base_folder --incremental-dir=$file
mv $file /data/historyBackup/
fi
done


mariabackup --copy-back --target-dir=/data/basics/base

chown -R mysql:mysql /data/mariadb