Installing Xtrabackup/qpress in Debian 12

MySQL & MariaDB
1

Hi
we have debian 12 system and we are trying to restore mysql backup taken using xtrabackup.
we have installed xtrabackup on debian 12 but unable to install qpress
its is required as our backup is compressed
Here is the command and output

$ xtrabackup --decompress --remove-original --target-dir=week_ending_2023_10_04/
xtrabackup: recognized server arguments:
xtrabackup: recognized client arguments: --decompress=1 --remove-original=1 --target-dir=week_ending_2023_10_04/
xtrabackup version 2.4.28 based on MySQL server 5.7.40 Linux (x86_64) (revision id: c77a5869)
231006 15:25:00 [01] decompressing ./xxxxxxxxxxx.frm.qp
sh: 1: qpress: not found
cat: write error: Broken pipe
Error: decrypt and decompress thread 0 failed.

$ sudo apt install qpress
Reading package lists… Done
Building dependency tree… Done
Reading state information… Done
Package qpress is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package ‘qpress’ has no installation candidate

2

Hello _Sumit_Debnath,
I think you just need to install one of the repo which have qpress.
You can follow below steps to install it ( i verified that on Debian 12 it’s working well )

sudo apt update
sudo apt install -y wget gnupg2 lsb-release curl
wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
sudo dpkg -i percona-release_latest.generic_all.deb
sudo apt update
sudo percona-release setup pxc80
sudo apt install qpress -y

Regards,
Denis Subbota.
Managed Services, Percona.