# Restoring DB is resulting in errors

**URL:** <https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852>\
**Category:** Percona XtraBackup\
**Created:** [July 28, 2025, 12:17am UTC](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852 "2025-07-28T00:17:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsodhia](https://avatars.discourse-cdn.com/v4/letter/r/2acd7d/32.png) [@rsodhia](https://forums.percona.com/u/rsodhia)\
**Post date:** [July 28, 2025, 12:17am UTC](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852/1 "2025-07-28T00:17:43Z")

</div>

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:

```auto
docker run --rm --name pxb \
  --volumes-from gpv1-mysql \
  -v backupvol:/backup_84 \
  --network=container:gpv1-mysql \
  -it --user root \
  percona/percona-xtrabackup:8.4 \
  /bin/bash -c "xtrabackup --backup --compress --datadir=/var/lib/mysql --target-dir=/backup_84 --host=gpv1-mysql --port=3306 --user=root --password=test123; xtrabackup --prepare --target-dir=/backup_84"

```

Then, to simulate some sort of fatal error, I removed the volume containing my MySQL data. I started the MySQL server up again to create the volume. Then, as per the docs, I copied the data from the backup to the MySQL data volume and verified the permissions, but get

```auto
2025-07-28T00:06:57.469628Z 0 [ERROR] [MY-011971] [InnoDB] Tablespace 'mysql' Page [page id: space=4294967294, page number=1435] log sequence number 31362109 is in the future! Current system log sequence number 31278350.
2025-07-28T00:06:57.469706Z 0 [ERROR] [MY-011972] [InnoDB] Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB redo log files. Please refer to http://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html for information about forcing recovery.

```

in the MySQL logs. Is there a step missing in the docs, or something I need to do in docker to get it working properly?

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [July 28, 2025, 10:05am UTC](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852/2 "2025-07-28T10:05:01Z")

</div>

Hi @rsodhia

> [@rsodhia](#):
>
> Then, as per the docs, I copied the data from the backup to the MySQL data volume and verified the permissions, but get

Have you used command “xtrabackup --copy-back …” ?

 ![Screenshot 2025-07-28 at 13.26.05](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/c/b/cbe87169a8d372bf61ce3c181046a1f48200a81a.png)

 ![Screenshot 2025-07-28 at 13.26.32](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/4/a/4a3066fda179fbddde1d9f99307e2519a3e62611.png)

---

<div class="post-metadata">

**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:** [July 28, 2025, 2:53pm UTC](https://forums.percona.com/t/restoring-db-is-resulting-in-errors/38852/3 "2025-07-28T14:53:03Z")

</div>

Hello @rsodhia,  
Please provide us with all commands you executed including the output/result. It is difficult to determine what might have happened without this info.