Restore xtrabackup compressed .qp files

MySQL & MariaDB Percona XtraBackup
1

Hi There

We have done a xtrabackup and used qpress to compress all the data.
We now want to restore this data which is .qp files and are having now such luck. Below are the scripts i ran. It runs with a completion OK but the db.'s are not uncompressed.
I would like to uncompress the files into a specific directory then prepare the files then restore.

Any help would be appreciated.
xtrabackup --decompress --target-dir=/mnt/restore/mysqlbackups

2

Hi @Bones52 ,

Can you please provide the full output of xtrabackup command.
You should be able to decompress .qp files with --decompress option.

3

@Bones52 Use --decompress and --remove-original then you can --prepare

4

thank you for the prompt response. Just a heads up this vm is currently being tested as a DR for the db restore. it is new with basic install of percona db and xtrabackup . Basically a blank vm with the apps. we restoring a db from our backup software which contains all the files to this test vm.

root@restore:/# xtrabackup --decompress --target-dir=/mnt/restore/mysqlbackups

2023-11-14T14:47:34.704681-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/var/lib/mysql

2023-11-14T14:47:34.704777-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --decompress=1 --target-dir=/mnt/restore/mysqlbackups

xtrabackup version 8.0.28-21 based on MySQL server 8.0.28 Linux (x86_64) (revision id: 78878e9b608)

2023-11-14T14:47:34.805131-00:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!

5

thanks for this but i did try it and got the same response >> complete ok

6

Hi @Bones52

This seems like xtrabackup did not find any files with .qp extention under /mnt/restore/mysqlbackups .

Can you please share the output of:

ls -lah /mnt/restore/mysqlbackups/

Thanks

7

ls -lah /mnt/restore/mysqlbackups/
total 8.0K
drwxr-xr-x 2 root root 4.0K Nov 14 14:47 .
drwxr-xr-x 6 root root 4.0K Nov 14 10:48 …

these are the .qp files retored from our backup application.

image
image1720×1008 239 KB

8

root@restore:/# xtrabackup --decompress --target-dir=/mnt/restore/mysqlbackups

You need to set --target-dir where the .qp are. From your ls command, /mnt/restore/mysqlbackups is an empty folder.

1 Like
9

OMG !!
THANK YOU !!!. Wrecked my brains thinking the target directory was where we want to put the uncompressed files into.
Really appreciate the prompt help.