# Restore xtrabackup compressed .qp files **URL:** \ **Category:** Percona XtraBackup\ **Created:** [November 14, 2023, 2:49pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532 "2023-11-14T14:49:01Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Bones52](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@Bones52](https://forums.percona.com/u/Bones52)\ **Post date:** [November 14, 2023, 2:49pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/1 "2023-11-14T14:49:01Z")
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 ---
**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\ **Post date:** [November 14, 2023, 3:12pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/2 "2023-11-14T15:12:46Z")
Hi @Bones52 , Can you please provide the full output of xtrabackup command. You should be able to decompress .qp files with --decompress option. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [November 14, 2023, 4:17pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/3 "2023-11-14T16:17:59Z")
@Bones52 Use `--decompress` and `--remove-original` then you can `--prepare` ---
**Author:** ![Bones52](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@Bones52](https://forums.percona.com/u/Bones52)\ **Post date:** [November 14, 2023, 6:51pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/4 "2023-11-14T18:51:34Z")
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! ---
**Author:** ![Bones52](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@Bones52](https://forums.percona.com/u/Bones52)\ **Post date:** [November 14, 2023, 6:52pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/5 "2023-11-14T18:52:46Z")
thanks for this but i did try it and got the same response \>\> complete ok ---
**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\ **Post date:** [November 14, 2023, 6:55pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/6 "2023-11-14T18:55:33Z")
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: ```auto ls -lah /mnt/restore/mysqlbackups/ ``` Thanks ---
**Author:** ![Bones52](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@Bones52](https://forums.percona.com/u/Bones52)\ **Post date:** [November 14, 2023, 7:03pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/7 "2023-11-14T19:03:11Z")
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](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/03b13307a8f4ab651a910fb6360191081de1bb4b.jpeg) ---
**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\ **Post date:** [November 14, 2023, 7:08pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/8 "2023-11-14T19:08:30Z")
> 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. ---
**Author:** ![Bones52](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@Bones52](https://forums.percona.com/u/Bones52)\ **Post date:** [November 14, 2023, 7:22pm UTC](https://forums.percona.com/t/restore-xtrabackup-compressed-qp-files/26532/9 "2023-11-14T19:22:53Z")
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.