Skip to content

Instantly share code, notes, and snippets.

@cnjax
Last active May 30, 2025 10:22
Show Gist options
  • Save cnjax/4105cb88c5acbf53a4b59628997b82f9 to your computer and use it in GitHub Desktop.
Save cnjax/4105cb88c5acbf53a4b59628997b82f9 to your computer and use it in GitHub Desktop.
restore qb.xb file
curl -O https://repo.percona.com/apt/percona-release_latest.generic_all.deb
apt install vim curl binutils net-tools gnupg2 lsb-release ./percona-release_latest.generic_all.deb
percona-release setup pxb-80 pxc-80 tools
#apt install percona-xtrabackup-80
apt install percona-xtrabackup-24
apt install qpress -y
xbstream -x -v -C ./mysql_bkdata/ <test_qp.xb
xtrabackup --decompress --remove-original --target-dir=mysql_bkdata/
xtrabackup --defaults-file=mysql_bkdata/backup-my.cnf --prepare --target-dir=./mysql_bkdata/
docker run -d --name=mysql_restore \
-v ./mysql_bkdata:/var/lib/mysql \
-e MYSQL_ALLOW_EMPTY_ROOT_PASSWORD=yes \
-p 13306:3306 \
--rm \
mysql:5.7 \
--skip-grant-tables
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment