恢复方法一：（比较节省时间）

1.数据解压缩：
-- mariadb恢复 stsz080095 -- 下面的起库命令和mysql一直 确保mysqld_safe用的
. /oracle_tmp/mysql_restore/prof_mariadb10.2.44
. /app/mysql/prof_mysql5.7.31
. /app/mysql/prof_mysql8.0.23

mariabackup --decompress --parallel=4 --remove-original --target-dir=$MYSQL_DATA_PATH 
mariabackup --prepare --use-memory=512M --target-dir=$MYSQL_DATA_PATH 

-- mysql恢复
nohup xtrabackup --decompress --parallel=4 --remove-original --target-dir=$MYSQL_DATA_PATH &
nohup xtrabackup --prepare --apply-log-only --use-memory=512M --target-dir=$MYSQL_DATA_PATH &

2.到解压缩好的路径下面编辑backup-my.cnf文件：
mv backup-my.cnf backup-my.cnf.bak_20231214
cat > backup-my.cnf<<EOF
[mysqld]
##innodb_checksum_algorithm=crc32
##innodb_log_checksum_algorithm=strict_crc32
innodb_data_file_path=ibdata1:12M:autoextend
innodb_log_files_in_group=3
innodb_log_file_size=1073741824 
#innodb_fast_checksum=false
innodb_page_size=16384
#innodb_log_block_size=512
innodb_undo_directory=./
innodb_undo_tablespaces=0
server_id=8009394
##redo_log_version=1
#server_uuid=78c3dc79-693c-11eb-80bf-e4434bfed7a5
#master_key_id=0
port=3308
lower-case-table-names=1
log-bin=OFF
#log-slave-updates = ON
EOF
cat backup-my.cnf

3.起库
mysqld_safe --defaults-file=./backup-my.cnf --log-error=/tmp/err.log --datadir=./ --innodb-data-home-dir=./ --skip-grant-tables --skip-networking &

tail -30f /tmp/err.log

mysql -h localhost --port=3308
show databases;
use dbamon
select * from delay_check;
exit
pwd
mysqladmin -h localhost --port=3308 shutdown
>/tmp/err.log

# 恢复方法二

su - brs
xtrabackup --decompress --parallel=12 --remove-original --target-dir=/mysql_backup/mysql/qppprd/f3354
xtrabackup --prepare --use-memory=512M  --target-dir=/mysql_backup/mysql/qppprd/f3354

cd /mysql_backup/mysql/qppprd/f3354
mysqld_safe  --log-error=./error.log  --socket=./my.socket --pid-file=/mysql_backup/mysql/qppprd/f3354/mysql.pid --basedir=/app/mysql/app --datadir=/mysql_backup/mysql/qppprd/f3354 --plugin-dir=/app/mysql/app/lib/plugin --lower-case-table-names=1 &

ps -ef|grep qppprd|grep -v grep >>result.out