XB


wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
apt update
apt install percona-xtrabackup-24 qpress -y  
cat aaa.xb| xbstream -x -v -C /mnt/hgfs/aaa
innobackupex --decompress --remove-original --target-dir=/mnt/hgfs/aaa
xtrabackup --decompress --remove-original --target-dir=/mnt/hgfs/aaa
xtrabackup --prepare --target-dir=/mnt/hgfs/aaa

# 7.修改配置文件,将配置里下面这些字段全部注释掉(行首加#)然后保存退出。
# innodb_checksum_algorithm 
# innodb_log_checksum_algorithm 
# innodb_fast_checksum 
# innodb_page_size 
# innodb_log_block_size 
# redo_log_version 
# server_uuid
# master_key_id
vi /root/backup-my.cnf 

services:

  db:
    image: mysql:5.6
    command:
#      --character-set-server=utf8mb4
#      --collation-server=utf8mb4_unicode_ci
#      --innodb_force_recovery=6
      --skip-grant-tables
    restart: always
#    environment:
#      MYSQL_ROOT_PASSWORD: 123456
    ports:
      - 13306:3306
    volumes:
      - /mnt/hgfs/P/data/:/var/lib/mysql

posted @ 2023-06-11 14:39  月渊  阅读(12)  评论(0编辑  收藏  举报