# Percona XtraBackup **URL:** https://forums.percona.com/c/mysql-mariadb/percona-xtrabackup/10.md?page=1 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 2 --- ## [Restoring DB is resulting in errors](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852)
**Author:** [@rsodhia](https://forums.percona.com/u/rsodhia)\ **Replies:** 2\ **Last updated:** [July 28, 2025, 2:53pm UTC](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852 "2025-07-28T14:53:03Z")
I’m testing using XtraBackup, and while I’m able to take a backup, restoring the backup isn’t working as I’d expect. As per the docs, I’m running the following to create the backup: docker run --rm --name pxb \\ --volu… --- ## [Connecting XtraBackup in docker to a container running in compose](https://forums.percona.com/t/connecting-xtrabackup-in-docker-to-a-container-running-in-compose/38780)
**Author:** [@rsodhia](https://forums.percona.com/u/rsodhia)\ **Replies:** 5\ **Last updated:** [July 25, 2025, 3:03pm UTC](https://forums.percona.com/t/connecting-xtrabackup-in-docker-to-a-container-running-in-compose/38780 "2025-07-25T15:03:22Z")
I’m running a MySQL instance in compose, with port 3306 exposed. I’m trying to figure out how I can use XtraBackup via docker to connect to the container. I’m running: docker run --name pxb --volumes-from gpv1-mysql -v … --- ## [Xtrabackup for redhat 7](https://forums.percona.com/t/xtrabackup-for-redhat-7/38816)
**Author:** [@ronnels](https://forums.percona.com/u/ronnels)\ **Replies:** 2\ **Last updated:** [July 25, 2025, 3:57am UTC](https://forums.percona.com/t/xtrabackup-for-redhat-7/38816 "2025-07-25T03:57:49Z")
Hello, Seems like there is no xtrabackup 8.4.3 Linux Generic Code for RedHat 7. Are you planning to build one or redhat 7 is no longer supported? --- ## [What reason to store binlog files to xtrabackup backup](https://forums.percona.com/t/what-reason-to-store-binlog-files-to-xtrabackup-backup/38712)
**Author:** [@yuskovich\_alexey](https://forums.percona.com/u/yuskovich_alexey)\ **Replies:** 1\ **Last updated:** [July 18, 2025, 4:48am UTC](https://forums.percona.com/t/what-reason-to-store-binlog-files-to-xtrabackup-backup/38712 "2025-07-18T04:48:04Z")
Hello There are two files in xtrabackup backup: mysql-bin.002103 mysql-bin.index What reason xtrabackup store them in backup? Is it safe to delete them? If not, why? My Mysql binlog directory not same, as database … --- ## [Migrating from Percona Server to Aurora with Xtrabackup](https://forums.percona.com/t/migrating-from-percona-server-to-aurora-with-xtrabackup/38500)
**Author:** [@Andrew2](https://forums.percona.com/u/Andrew2)\ **Replies:** 1\ **Last updated:** [June 30, 2025, 3:30pm UTC](https://forums.percona.com/t/migrating-from-percona-server-to-aurora-with-xtrabackup/38500 "2025-06-30T15:30:08Z")
I’m looking at migrating some of our Percona Server on EC2 instances into Aurora but reading the AWS documentation ( Physical migration from MySQL by using Percona XtraBackup and Amazon S3 - Amazon Aurora ) I noticed thi… --- ## [Xtrabackup run fails, indicating missed binary log file](https://forums.percona.com/t/xtrabackup-run-fails-indicating-missed-binary-log-file/38461)
**Author:** [@bklk](https://forums.percona.com/u/bklk)\ **Replies:** 3\ **Last updated:** [June 29, 2025, 2:43pm UTC](https://forums.percona.com/t/xtrabackup-run-fails-indicating-missed-binary-log-file/38461 "2025-06-29T14:43:55Z")
Hello Forum, I’m looking for some clues how to tackle following problem: There are 2 MySQL nodes (let’s call them X and Y), each of them is using the following: OS: AlmaLinux release 9.6 MySQL: 8.0.36-28 Percona Serv… --- ## [LSN logged when preparing a backup doesn't match the value of to\_lsn](https://forums.percona.com/t/lsn-logged-when-preparing-a-backup-doesnt-match-the-value-of-to-lsn/37146)
**Author:** [@Jean-Luc\_Derrien](https://forums.percona.com/u/Jean-Luc_Derrien)\ **Replies:** 7\ **Last updated:** [June 18, 2025, 4:50pm UTC](https://forums.percona.com/t/lsn-logged-when-preparing-a-backup-doesnt-match-the-value-of-to-lsn/37146 "2025-06-18T16:50:27Z")
Hello, I’m trying to restore an incremental backup made with xtrabackup following this doc: Prepare an incremental backup - Percona XtraBackup I’m preparing the base backup with this command: $ xtrabackup --prepare --a… --- ## [Xtrabackup hangs unexpectedly](https://forums.percona.com/t/xtrabackup-hangs-unexpectedly/38262)
**Author:** [@james\_at\_upmind](https://forums.percona.com/u/james_at_upmind)\ **Replies:** 3\ **Last updated:** [June 12, 2025, 8:31am UTC](https://forums.percona.com/t/xtrabackup-hangs-unexpectedly/38262 "2025-06-12T08:31:09Z")
I’m using Vitess in Kubernetes, and I’m trying to take a backup of one of my databases. Vitess abstracts the backup process, but it essentially runs the following in a running container: xtrabackup --defaults-file=/vt/… --- ## [Cannot generate .cfg files when preparing incremental backups with --export](https://forums.percona.com/t/cannot-generate-cfg-files-when-preparing-incremental-backups-with-export/37961)
**Author:** [@Eedjeeze](https://forums.percona.com/u/Eedjeeze)\ **Replies:** 5\ **Last updated:** [May 22, 2025, 2:21pm UTC](https://forums.percona.com/t/cannot-generate-cfg-files-when-preparing-incremental-backups-with-export/37961 "2025-05-22T14:21:55Z")
Hello ! While running xtrabackup --prepare --export --target-dir=$BACKUP\_DIR/full does everything as expected, trying to do the same thing with incremental backups does not generate .cfg files. My process is: xtraback… --- ## [Error in xtrabackup prepare: "cannot open ./xtrabackup\_logfile"](https://forums.percona.com/t/error-in-xtrabackup-prepare-cannot-open-xtrabackup-logfile/37868)
**Author:** [@toby5box](https://forums.percona.com/u/toby5box)\ **Replies:** 8\ **Last updated:** [May 14, 2025, 4:26am UTC](https://forums.percona.com/t/error-in-xtrabackup-prepare-cannot-open-xtrabackup-logfile/37868 "2025-05-14T04:26:43Z")
Hi, I am testing a legacy backup system and am having problems at the prepare step. The backup is to S3, of mysql 8.0.21, using xtrabackup version 8.0.25-17 based on MySQL server 8.0.25 Linux (x86\_64) (revision id: d27… --- ## [Percona xtrabackup not working with xbstream](https://forums.percona.com/t/percona-xtrabackup-not-working-with-xbstream/37863)
**Author:** [@Jyoti\_Rajai](https://forums.percona.com/u/Jyoti_Rajai)\ **Replies:** 3\ **Last updated:** [May 9, 2025, 2:03am UTC](https://forums.percona.com/t/percona-xtrabackup-not-working-with-xbstream/37863 "2025-05-09T02:03:39Z")
Hello, I am trying take backup using below syntax but getting errors : xtrabackup --backup --databases="${DB}" --stream=xbstream --compress --compress-threads=2 --parallel=2 --user="${MYSQL\_USER}" | t… --- ## [XtraBackup for MySQL 8.0.36](https://forums.percona.com/t/xtrabackup-for-mysql-8-0-36/29461)
**Author:** [@asamofal](https://forums.percona.com/u/asamofal)\ **Replies:** 11\ **Last updated:** [April 30, 2025, 4:03am UTC](https://forums.percona.com/t/xtrabackup-for-mysql-8-0-36/29461 "2025-04-30T04:03:32Z")
Hi. Where’s Percona XtraBackup 8.0.36? percona-server:8.0.36-28.1 was released on Mar 4, 2024, almost a month ago. What XtraBackup version I can use for this? --- ## [Using Percona Xtrabackup to migrate MySQL server from one VM to another VM](https://forums.percona.com/t/using-percona-xtrabackup-to-migrate-mysql-server-from-one-vm-to-another-vm/37636)
**Author:** [@Nitish1](https://forums.percona.com/u/Nitish1)\ **Replies:** 12\ **Last updated:** [April 25, 2025, 10:05pm UTC](https://forums.percona.com/t/using-percona-xtrabackup-to-migrate-mysql-server-from-one-vm-to-another-vm/37636 "2025-04-25T22:05:39Z")
Scenario: Using percona xtrabackup to take online backup and migrate to another VM. Steps performed: Run backup command Run prepare command Copy the files from this VM to another VM and overwrite the data dictionary o… --- ## [Too Many Open Files - MySql 8.0.26](https://forums.percona.com/t/too-many-open-files-mysql-8-0-26/37737)
**Author:** [@Senktron](https://forums.percona.com/u/Senktron)\ **Replies:** 5\ **Last updated:** [April 25, 2025, 10:04pm UTC](https://forums.percona.com/t/too-many-open-files-mysql-8-0-26/37737 "2025-04-25T22:04:12Z")
Hi Everyone! I have a database with over 2M files, tried to backup with xtrabackup, and even using the parameter close-files, i have the error of too many files, my open\_file\_limits is set to 300k and i checked in realt… --- ## [Xtrabackup failure - xbcloud upload failure](https://forums.percona.com/t/xtrabackup-failure-xbcloud-upload-failure/37675)
**Author:** [@bklk](https://forums.percona.com/u/bklk)\ **Replies:** 5\ **Last updated:** [April 22, 2025, 4:06pm UTC](https://forums.percona.com/t/xtrabackup-failure-xbcloud-upload-failure/37675 "2025-04-22T16:06:19Z")
Hello, I’m looking for help with xtrabackup problem. the xtrabackup command: xtrabackup --user=... --password=... --backup --datadir=/data/mysql/data --stream=xbstream --read-buffer-size=500M --extra-lsndir=/tmp --ta… --- ## [Xtrabackup "silent mode"?](https://forums.percona.com/t/xtrabackup-silent-mode/37582)
**Author:** [@Francesco\_Montanari](https://forums.percona.com/u/Francesco_Montanari)\ **Replies:** 2\ **Last updated:** [April 12, 2025, 7:01am UTC](https://forums.percona.com/t/xtrabackup-silent-mode/37582 "2025-04-12T07:01:15Z")
I run daily xtrabackups on several machines via Cron, and all the output is sent to my email thanks to the MAILTO= directive in /etc/crontab This setup is working, as I can verify if everything is fine by checking if th… --- ## [Migration from MySQL 5.5 (FreeBSD 9.1) to MySQL 8.0 using Percona XtraBackup 2.4](https://forums.percona.com/t/migration-from-mysql-5-5-freebsd-9-1-to-mysql-8-0-using-percona-xtrabackup-2-4/37519)
**Author:** [@8951696985mg](https://forums.percona.com/u/8951696985mg)\ **Replies:** 2\ **Last updated:** [April 7, 2025, 5:13pm UTC](https://forums.percona.com/t/migration-from-mysql-5-5-freebsd-9-1-to-mysql-8-0-using-percona-xtrabackup-2-4/37519 "2025-04-07T17:13:08Z")
Hello! I am planning to migrate a database from a server running MySQL 5.5 (InnoDB) to a new version, MySQL 8.0. For this purpose, I intend to use Percona XtraBackup 2.4 . Below are the details of my current configurati… --- ## [Xtrabackup flushing binary logs while still locked](https://forums.percona.com/t/xtrabackup-flushing-binary-logs-while-still-locked/37490)
**Author:** [@IGGt](https://forums.percona.com/u/IGGt)\ **Replies:** 4\ **Last updated:** [April 4, 2025, 3:25pm UTC](https://forums.percona.com/t/xtrabackup-flushing-binary-logs-while-still-locked/37490 "2025-04-04T15:25:39Z")
I’m just trying to ascertain if I have a Bug or not with xtrabackup, or if it is intended to work this way. I am using: MySQL (Oracle): 8.0.39 xtrabackup version: 8.0.35-31 When xtrabackup runs it runs using the --lo… --- ## [How to restore incremental streaming backup with xbstream (getting file exists error)](https://forums.percona.com/t/how-to-restore-incremental-streaming-backup-with-xbstream-getting-file-exists-error/37477)
**Author:** [@Justin\_Swanhart](https://forums.percona.com/u/Justin_Swanhart)\ **Replies:** 1\ **Last updated:** [April 4, 2025, 3:15pm UTC](https://forums.percona.com/t/how-to-restore-incremental-streaming-backup-with-xbstream-getting-file-exists-error/37477 "2025-04-04T15:15:22Z")
I have taken an incremental backup of the database in streaming format using the --stream=xbstream and --incremental-lsn command line options. When I restore my full backup, I run xtrabackup --prepare --apply-log-only -… --- ## [How to restore backups without using xbcloud](https://forums.percona.com/t/how-to-restore-backups-without-using-xbcloud/37074)
**Author:** [@ronn\_h](https://forums.percona.com/u/ronn_h)\ **Replies:** 5\ **Last updated:** [April 4, 2025, 12:02pm UTC](https://forums.percona.com/t/how-to-restore-backups-without-using-xbcloud/37074 "2025-04-04T12:02:41Z")
As per the new feature of FIFO DATA SINK, we can write data from xtrabackup to multiple pipes. Ref: FIFO data sink - Percona XtraBackup. We have a software which can read from the fifo pipes and store the data into a st… --- ## [Need Help in taking incremental backup of my managed sql instance on GCP](https://forums.percona.com/t/need-help-in-taking-incremental-backup-of-my-managed-sql-instance-on-gcp/37345)
**Author:** [@Nilesh\_Bhardwaj](https://forums.percona.com/u/Nilesh_Bhardwaj)\ **Replies:** 5\ **Last updated:** [April 1, 2025, 12:34pm UTC](https://forums.percona.com/t/need-help-in-taking-incremental-backup-of-my-managed-sql-instance-on-gcp/37345 "2025-04-01T12:34:31Z")
Hello everybody, I am not clear on the procedure for implementing daily incremental backups for a production-managed SQL instance on GCP with zero impact on operations (if possible). Background & Approach I plan to de… --- ## [Xtrabackup : best options for performance](https://forums.percona.com/t/xtrabackup-best-options-for-performance/37187)
**Author:** [@dba\_S4dscjz](https://forums.percona.com/u/dba_S4dscjz)\ **Replies:** 2\ **Last updated:** [March 21, 2025, 4:36pm UTC](https://forums.percona.com/t/xtrabackup-best-options-for-performance/37187 "2025-03-21T16:36:37Z")
Hello everyone, For our needs we realize daily backups of our database and each backup piece is sent to a block storage object in cloud provider. So the executed command looks like : xtrabackup --stream=xbstream | xbcl… --- ## [PXB 8.4.0 causes Percona Server 8.4.2-2 to crash when a backup is run](https://forums.percona.com/t/pxb-8-4-0-causes-percona-server-8-4-2-2-to-crash-when-a-backup-is-run/35444)
**Author:** [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\ **Replies:** 7\ **Last updated:** [March 21, 2025, 8:20am UTC](https://forums.percona.com/t/pxb-8-4-0-causes-percona-server-8-4-2-2-to-crash-when-a-backup-is-run/35444 "2025-03-21T08:20:26Z")
When I try to run a simple backup on a Percona Server 8.4.2-2 using Xtrabackup 8.4.0-1, I am hitting a hard crash on Percona Server. Command used: xtrabackup --backup --target-dir=/backupdir The backup fails with thi… --- ## [Xtrabackup restore to point in time](https://forums.percona.com/t/xtrabackup-restore-to-point-in-time/37065)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 1\ **Last updated:** [March 6, 2025, 1:20pm UTC](https://forums.percona.com/t/xtrabackup-restore-to-point-in-time/37065 "2025-03-06T13:20:07Z")
Is there a way to restore to a specific point in time by specifying a date and time in xtrabackup? example if I want to restore to 7am Feb 20 2025? I have a weekly full backup and incremental daily backups. Thanks --- ## [Restore backup on a replica - still need to set gtid\_purged?](https://forums.percona.com/t/restore-backup-on-a-replica-still-need-to-set-gtid-purged/37031)
**Author:** [@Charly\_Wu](https://forums.percona.com/u/Charly_Wu)\ **Replies:** 1\ **Last updated:** [March 6, 2025, 12:57pm UTC](https://forums.percona.com/t/restore-backup-on-a-replica-still-need-to-set-gtid-purged/37031 "2025-03-06T12:57:48Z")
In How to create a new (or repair a broken) GTID-based replica in step 4: Set the gtid\_purged variable to the GTID from xtrabackup\_binlog\_info. Then, update the information about the source node and, finally, start the… --- ## [Using an environment variable for MySQL password in xtrabackup 8.0](https://forums.percona.com/t/using-an-environment-variable-for-mysql-password-in-xtrabackup-8-0/36947)
**Author:** [@Leigh\_Dyer](https://forums.percona.com/u/Leigh_Dyer)\ **Replies:** 6\ **Last updated:** [March 3, 2025, 10:34am UTC](https://forums.percona.com/t/using-an-environment-variable-for-mysql-password-in-xtrabackup-8-0/36947 "2025-03-03T10:34:08Z")
Hi, I’m currently beginning to upgrade our production environment to Percona Server 8.0, and as part of that we’ll be moving backups from xtrabackup 2.4 to xtrabackup 8.0. One thing I’m struggling with, though, is passin… --- ## [Xtrabackup 8.4.2](https://forums.percona.com/t/xtrabackup-8-4-2/36940)
**Author:** [@ronnels](https://forums.percona.com/u/ronnels)\ **Replies:** 1\ **Last updated:** [February 26, 2025, 7:31pm UTC](https://forums.percona.com/t/xtrabackup-8-4-2/36940 "2025-02-26T19:31:18Z")
Is xtrabackup 8.4.2 compatible with MySQL 8.4.4? Thank you --- ## [Could not parse Vault Server response](https://forums.percona.com/t/could-not-parse-vault-server-response/30798)
**Author:** [@Danie\_Le\_Roux](https://forums.percona.com/u/Danie_Le_Roux)\ **Replies:** 21\ **Last updated:** [February 26, 2025, 12:00pm UTC](https://forums.percona.com/t/could-not-parse-vault-server-response/30798 "2025-02-26T12:00:42Z")
Hi, Xtrabackup is failing to complete on server with 85+ encrypted databases due to Vault Errors. When running xtrabackup for a single database using --databases flag the backup completes successfully (no vault issues)… --- ## [Percona Server 8.4 MySQL Commvault Backup getting stuck](https://forums.percona.com/t/percona-server-8-4-mysql-commvault-backup-getting-stuck/36820)
**Author:** [@Srikanth\_Lingala](https://forums.percona.com/u/Srikanth_Lingala)\ **Replies:** 1\ **Last updated:** [February 22, 2025, 1:30am UTC](https://forums.percona.com/t/percona-server-8-4-mysql-commvault-backup-getting-stuck/36820 "2025-02-22T01:30:04Z")
Hi Team We have two separate instances setup as below with same configuration: Percona Server MySQL 8.0 running on RHEL 9. Percona Server MySQL 8.4 running on RHEL 9. While the first one runs successfully without any… --- ## [Xtrabackup with the latest version does not prepare bkps made in the previous version?](https://forums.percona.com/t/xtrabackup-with-the-latest-version-does-not-prepare-bkps-made-in-the-previous-version/36606)
**Author:** [@CharlesR](https://forums.percona.com/u/CharlesR)\ **Replies:** 1\ **Last updated:** [February 10, 2025, 2:58pm UTC](https://forums.percona.com/t/xtrabackup-with-the-latest-version-does-not-prepare-bkps-made-in-the-previous-version/36606 "2025-02-10T14:58:44Z")
Hi, I made a backup using Xtrabackup version 8.4.0-1 but when I tried to prepare the backup in xtrabackup version 8.4.0-2 I received the error: 2025-02-09T11:07:15.429993-03:00 0 \[ERROR\] \[MY-011825\] \[Xtrabackup\] Failed… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-xtrabackup/10.md) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-xtrabackup/10.md?page=2)