# Xtrabackup - 8.0.35-31 - Does not apply the incremental **URL:** \ **Category:** Percona XtraBackup\ **Created:** [August 14, 2024, 10:12pm UTC](https://forums.percona.com/t/xtrabackup-8-0-35-31-does-not-apply-the-incremental/32284 "2024-08-14T22:12:11Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![CharlesR](https://avatars.discourse-cdn.com/v4/letter/c/54ee81/32.png) [@CharlesR](https://forums.percona.com/u/CharlesR)\ **Post date:** [August 14, 2024, 10:12pm UTC](https://forums.percona.com/t/xtrabackup-8-0-35-31-does-not-apply-the-incremental/32284/1 "2024-08-14T22:12:11Z")
Hi, I ran the full backup command: xtrabackup --backup --target-dir=/dados/percona/base/ I created a database B with a test table. I ran the command for the incremental backup: xtrabackup --backup --target-dir=/dados/percona/inc1 --incremental-basedir=/dados/percona/base I prepared the full backup and then I prepared the incremental backup. xtrabackup --prepare --apply-log-only --target-dir=/dados/percona/base 2024-08-14T19:10:34.498009-03:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20932320 2024-08-14T19:10:34.503028-03:00 0 [Note] [MY-011825] [Xtrabackup] completed OK! xtrabackup --prepare --target-dir=/dados/percona/base --incremental-basedir=/dados/percona/inc1 2024-08-14T19:11:37.034280-03:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20933142 2024-08-14T19:11:37.038723-03:00 0 [Note] [MY-011825] [Xtrabackup] completed OK! When restoring the backup, table B is not in the database. Am I doing something wrong or is there a bug in the xtrabackup version? Infos: MySQL version: 8.0.39 xtrabackup version 8.0.35-31 Ubuntu 22.04.4 LTS base/xtrabackup\_checkpoints backup\_type = log-applied from\_lsn = 0 to\_lsn = 20981409 last\_lsn = 20981409 flushed\_lsn = 20981409 redo\_memory = 0 redo\_frames = 0 inc1/xtrabackup\_checkpoints backup\_type = incremental from\_lsn = 20981409 to\_lsn = 20998433 last\_lsn = 20998433 flushed\_lsn = 20998433 redo\_memory = 0 redo\_frames = 0 ls -lah base/ total 90M drwxr-x— 8 root root 4.0K Aug 14 18:50 . drwxr-xr-x 4 root root 30 Aug 14 18:44 … drwxr-x— 2 root root 29 Aug 14 18:43 a -rw-r----- 1 root root 447 Aug 14 18:43 backup-my.cnf -rw-r----- 1 root root 157 Aug 14 18:43 binlog.000016 -rw-r----- 1 root root 16 Aug 14 18:43 binlog.index -rw-r----- 1 root root 3.4K Aug 14 18:43 ib\_buffer\_pool -rw-r----- 1 root root 12M Aug 14 18:50 ibdata1 -rw-r----- 1 root root 12M Aug 14 18:50 ibtmp1 drwxr-x— 2 root root 6 Aug 14 18:50 ‘#innodb\_redo’ drwxr-x— 2 root root 143 Aug 14 18:43 mysql -rw-r----- 1 root root 25M Aug 14 18:43 mysql.ibd drwxr-x— 2 root root 8.0K Aug 14 18:43 performance\_schema drwxr-x— 2 root root 36 Aug 14 18:43 sys drwxr-x— 2 root root 28 Aug 14 18:43 tmp -rw-r----- 1 root root 16M Aug 14 18:43 undo\_001 -rw-r----- 1 root root 16M Aug 14 18:43 undo\_002 -rw-r----- 1 root root 18 Aug 14 18:43 xtrabackup\_binlog\_info -rw-r----- 1 root root 132 Aug 14 18:50 xtrabackup\_checkpoints -rw-r----- 1 root root 473 Aug 14 18:43 xtrabackup\_info -rw-r----- 1 root root 8.0M Aug 14 18:45 xtrabackup\_logfile -rw-r----- 1 root root 39 Aug 14 18:50 xtrabackup\_tablespaces ls -lah inc1/ total 1.1M drwxr-x— 8 root root 4.0K Aug 14 18:44 . drwxr-xr-x 4 root root 30 Aug 14 18:44 … drwxr-x— 2 root root 59 Aug 14 18:44 a **drwxr-x— 2 root root 61 Aug 14 18:44 b** -rw-r----- 1 root root 447 Aug 14 18:44 backup-my.cnf -rw-r----- 1 root root 157 Aug 14 18:44 binlog.000017 -rw-r----- 1 root root 16 Aug 14 18:44 binlog.index -rw-r----- 1 root root 3.4K Aug 14 18:44 ib\_buffer\_pool -rw-r----- 1 root root 48K Aug 14 18:44 ibdata1.delta -rw-r----- 1 root root 64 Aug 14 18:44 ibdata1.meta drwxr-x— 2 root root 143 Aug 14 18:44 mysql -rw-r----- 1 root root 640K Aug 14 18:44 mysql.ibd.delta -rw-r----- 1 root root 73 Aug 14 18:44 mysql.ibd.meta drwxr-x— 2 root root 8.0K Aug 14 18:44 performance\_schema drwxr-x— 2 root root 61 Aug 14 18:44 sys drwxr-x— 2 root root 28 Aug 14 18:44 tmp -rw-r----- 1 root root 128K Aug 14 18:44 undo\_001.delta -rw-r----- 1 root root 69 Aug 14 18:44 undo\_001.meta -rw-r----- 1 root root 176K Aug 14 18:44 undo\_002.delta -rw-r----- 1 root root 69 Aug 14 18:44 undo\_002.meta -rw-r----- 1 root root 18 Aug 14 18:44 xtrabackup\_binlog\_info -rw-r----- 1 root root 139 Aug 14 18:44 xtrabackup\_checkpoints -rw-r----- 1 root root 521 Aug 14 18:44 xtrabackup\_info -rw-r----- 1 root root 2.5K Aug 14 18:44 xtrabackup\_logfile -rw-r----- 1 root root 39 Aug 14 18:44 xtrabackup\_tablespaces ---
**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:** [August 14, 2024, 10:23pm UTC](https://forums.percona.com/t/xtrabackup-8-0-35-31-does-not-apply-the-incremental/32284/2 "2024-08-14T22:23:19Z")
Percona has not released an 8.0.39. Are you using community MySQL? Are you aware of the [serious bug](https://www.percona.com/blog/severe-instability-of-mysql-8-0-38-8-4-1-and-9-0-resolved-in-upcoming-releases/) back in 8.0.38? I would repeat your test on the latest Percona 8.0.37 and verify these results firstly. ---
**Author:** ![CharlesR](https://avatars.discourse-cdn.com/v4/letter/c/54ee81/32.png) [@CharlesR](https://forums.percona.com/u/CharlesR)\ **Post date:** [August 14, 2024, 10:32pm UTC](https://forums.percona.com/t/xtrabackup-8-0-35-31-does-not-apply-the-incremental/32284/3 "2024-08-14T22:32:22Z")
Hi Mattewb, Find the problem. I was using the command incorrectly but it didn’t warn me. Wrong: xtrabackup --prepare --target-dir=/dados/percona/base **–incremental-basedir** =/dados/percona/inc1 Correct: xtrabackup --prepare --target-dir=/dados/percona/base **–incremental-dir** =/dados/percona/inc1 Questions: I’m using the latest version of the community MySQL 8.0 And the latest version of xtrabackup is 8.0.35-31, as can be seen on the website. > **[Percona XtraBackup - Percona XtraBackup 8.0.35-31 (2024-06-20)](https://docs.percona.com/percona-xtrabackup/8.0/release-notes/8.0/8.0.35-31.0.html)** > > Get started with Quickstart Guide for Percona XtraBackup. Thanks!