xtrabackup手工备份恢复

## 5.7 版本备份方式
# 全备
mkdir /data/backup/20210708_full -p 
innobackupex --defaults-file=/etc/my.cnf --user=root --password=123456 --port=3306 --parallel=4 --compress --compress-threads=8 --no-timestamp /data/backup/20210708_full

# 增备
mkdir /data/backup/20210708_inc -p 
innobackupex --defaults-file=/etc/my.cnf --user=root --password=123456 --port=3306 --parallel=4 --compress --compress-threads=8 --no-timestamp --incremental /data/backup/20210708_inc --incremental-basedir /data/backup/20210708_full


# 恢复全备
cp -r /data/backup/mysql/192.168.68.88/20210704_031001_full_bak /data/temp/3306
xtrabackup --decompress --target-dir=/data/temp/3306/20210704_031001_full_bak
xtrabackup --prepare --apply-log-only --use-memory=4G --target-dir=/data/temp/3306/20210704_031001_full_bak

# 增量备份
cp -r /data/backup/mysql/192.168.68.88/20210705_031001_incr_bak /data/temp/3306
cp -r /data/backup/mysql/192.168.68.88/20210706_031001_incr_bak /data/temp/3306
cp -r /data/backup/mysql/192.168.68.88/20210707_031001_incr_bak /data/temp/3306

xtrabackup --decompress --target-dir=/data/temp/3306/20210705_031001_incr_bak
xtrabackup --decompress --target-dir=/data/temp/3306/20210706_031001_incr_bak
xtrabackup --decompress --target-dir=/data/temp/3306/20210707_031001_incr_bak

xtrabackup --prepare --apply-log-only --use-memory=4G --target-dir=/data/temp/3306/20210704_031001_full_bak --incremental-dir=/data/temp/3306/20210705_031001_incr_bak
xtrabackup --prepare --apply-log-only --use-memory=4G --target-dir=/data/temp/3306/20210704_031001_full_bak --incremental-dir=/data/temp/3306/20210706_031001_incr_bak
xtrabackup --prepare --apply-log-only --use-memory=4G --target-dir=/data/temp/3306/20210704_031001_full_bak --incremental-dir=/data/temp/3306/20210707_031001_incr_bak

# 拷贝到数据目录
xtrabackup --defaults-file=/etc/my.cnf  --copy-back --target-dir=/data/temp/3306/20210704_031001_full_bak
chown mysql:mysql -R /data/mysql/
/etc/init.d/mysqld start 
 
 
## 8.0 版本备份方式
# 8.0 全备
xtrabackup  --defaults-file=/etc/my.cnf  --protocol=tcp --user=root --password=123456 --port=3306 --socket=/data/mysql/mysql.sock --parallel=4 --compress --compress-threads=8 --no-timestamp  --backup  --target-dir=/data/temp/3306/20210704_031001_incr_bak  

# 8.0 增备
xtrabackup  --defaults-file=/etc/my.cnf  --protocol=tcp --user=root --password=123456 --port=3306 --socket=/data/mysql/mysql.sock --parallel=4 --compress --compress-threads=8 --no-timestamp  --backup --incremental --target-dir=/data/temp/3306/20210704_031001_incr_bak   --incremental-basedir /data/temp/3306/20210704_031001_full_bak