# XtraBackup Restore Issue – Database Not Recognized but mysqldump Works **URL:** \ **Category:** Uncategorized\ **Created:** [April 11, 2026, 9:13pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621 "2026-04-11T21:13:13Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 11, 2026, 9:13pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/1 "2026-04-11T21:13:14Z")
**Subject:** XtraBackup Restore Issue – Database Not Recognized but mysqldump Works **Environment:** - Backup Server: - Restore Server: * * * **Backup Command Used:** xtrabackup --backup --target-dir=/backup/Mysqlbackup --parallel=4 --user=root --password=XXXX * * * **Restore Steps:** 1. xtrabackup --prepare --target-dir=/backup/Mysqlbackup 2. systemctl stop mysql 3. rm -rf /media/vdata/mysql/\* 4. xtrabackup --copy-back --target-dir=/backup/Mysqlbackup 5. chown -R mysql:mysql /media/vdata/mysql 6. rm -f /media/vdata/mysql/auto.cnf 7. systemctl start mysql * * * **Observed Behavior:** - Restore completes without error - MySQL starts successfully - Database folder (centraldb) exists in datadir - However, database is not properly recognized in some restore attempts * * * **Validation:** - Both source and restore servers show: SHOW DATABASES → centraldb only - Data consistency verified (row count matches) - mysqldump backup/restore works perfectly * * * **Key Checks Already Done:** - innodb\_file\_per\_table = ON (both servers) - lower\_case\_table\_names = 0 (both servers) - Datadir correctly configured - Backup contents verified (centraldb present) - Only one MySQL instance running - Permissions set correctly * * * **Error Log Snippet:** - “No existing UUID has been found… generating new UUID” - Server upgrade from 8.0.42 to 8.0.45 observed - No major InnoDB corruption errors seen * * * **Concern:** It appears that MySQL initializes a new InnoDB dictionary (possibly due to early startup or redo log mismatch), causing XtraBackup restored data to not be properly recognized, while mysqldump works fine. * * * **Request:** - Guidance on ensuring proper InnoDB dictionary recognition after restore - Best practice to avoid UUID / initialization conflicts - Any known compatibility issues between MySQL 8.0.42 → 8.0.45 with XtraBackup 8.0.35 * * * **Additional Info (if needed):** Can provide full error logs, backup directory structure, and configuration files. Thanks in advance for your support. ---
**Author:** ![hai.nguyen](https://avatars.discourse-cdn.com/v4/letter/h/41988e/32.png) [@hai.nguyen](https://forums.percona.com/u/hai.nguyen)\ **Post date:** [April 13, 2026, 12:12am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/2 "2026-04-13T00:12:33Z")
Hi @viswanatha. Could you share the backup, prepare and error log? ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 13, 2026, 5:55am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/3 "2026-04-13T05:55:41Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/7/f/7f56b9bfe281f24de5c394480ad2370b74f27b8d.jpeg) Please find the error log. ---
**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\ **Post date:** [April 13, 2026, 4:25pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/4 "2026-04-13T16:25:34Z")
Hi viswanatha, When restoring try to use same or higher xtrabackup to avoid any incompatibilities or unknown bug. This time you are backing up with -32 but restoring with -31 (older) Regards ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 15, 2026, 6:26am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/6 "2026-04-15T06:26:30Z")
In ubuntu 22 its already the newest version.XtraBackup Version: 8.0.35-31 ---
**Author:** ![hai.nguyen](https://avatars.discourse-cdn.com/v4/letter/h/41988e/32.png) [@hai.nguyen](https://forums.percona.com/u/hai.nguyen)\ **Post date:** [April 15, 2026, 6:53am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/7 "2026-04-15T06:53:14Z")
Could you try updating the package list? ```auto sudo apt update ``` I can still see newer versions in Ubuntu 22.04.5 LTS: ```auto # apt list -a percona-xtrabackup-80 Listing... Done percona-xtrabackup-80/unknown 8.0.35-35-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.35-34-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.35-33-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.35-32-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.35-31-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.35-30-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.34-29-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.33-28-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.33-27-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.32-26-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.32-25-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.31-24-1.jammy amd64 percona-xtrabackup-80/unknown 8.0.30-23-1.jammy amd64 ``` > **[Percona XtraBackup - Percona release and APT](https://docs.percona.com/percona-xtrabackup/8.0/apt-repo.html)** > > Ready-to-use packages are available from the Percona XtraBackup software > repositories and the download page. ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 15, 2026, 7:35am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/8 "2026-04-15T07:35:30Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/8/e/8e80fc66368bb4661f393df09fc173cffd4dfe65.png) > [@hai.nguyen](#): > > `percona-xtrabackup-80/unknown 8.0.35-31-1.jammy am` > > ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/3/e/3ed33191a1d78c5f7e8ffaa7326989688e5c3214.jpeg) ---
**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\ **Post date:** [April 15, 2026, 11:45am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/9 "2026-04-15T11:45:54Z")
Hi again! Try with percona-release [Configure Percona repositories - Percona Software Repositories](https://docs.percona.com/percona-software-repositories/percona-release.html) You can also downgrade the PXB package on the source to match PXB on the destination server. Or you can also download the tarballs from [percona.com/downloads](http://percona.com/downloads) to match versions Regards ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 16, 2026, 8:22am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/10 "2026-04-16T08:22:50Z")
> [@viswanatha](#): > > XtraBackup Version: 8.0.35-32 Version Changed still the same issue DB not recognised. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/b/8/b8014298c7b7f4bdc6a476173287d26a7a1456d1.jpeg) ---
**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\ **Post date:** [April 16, 2026, 12:35pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/11 "2026-04-16T12:35:15Z")
Hi again! Reasons can be many. Please start by checking that the backup completed successfully. The last line in the log should say “Backup completed successfully”. Another possibility is wrong permissions. Check that file ownership of the files is for the “mysql” user and not root Regards ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 16, 2026, 12:39pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/12 "2026-04-16T12:39:48Z")
Backup completed successfully, & permission is also ok. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/9/f/9fb9b2c98460c76fc3af81c0bc0e524971c485a3.png) ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 17, 2026, 6:02am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/13 "2026-04-17T06:02:19Z")
Mysqldump and rsync are working fine, but xtrabackup fails. During backup/restore, MySQL starts successfully, but in the final stage it throws a “database not available” error. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/b/f/bf0ae09d671788341d44dccc139c275476af505c.jpeg) ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 17, 2026, 7:21am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/14 "2026-04-17T07:21:22Z")
Checked with both Backup & Restore xtrabackup version 8.0.35-35 the same issue persists. ---
**Author:** ![hai.nguyen](https://avatars.discourse-cdn.com/v4/letter/h/41988e/32.png) [@hai.nguyen](https://forums.percona.com/u/hai.nguyen)\ **Post date:** [April 17, 2026, 7:43am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/15 "2026-04-17T07:43:31Z")
It’d be great if you can share the mysql error log. The current log that you shared seems to be application log. ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 17, 2026, 8:13am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/16 "2026-04-17T08:13:06Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/c/8/c82f58cd1c1bac62ec0a1b84465afe18368ee98f.jpeg) ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 20, 2026, 1:27pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/17 "2026-04-20T13:27:33Z")
Also tried in another system, still the same issue, DB not available. ---
**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\ **Post date:** [April 20, 2026, 1:36pm UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/18 "2026-04-20T13:36:51Z")
Hi again! Can you please mention the steps you are doing to restore the backup? Also, have you successfully used xtrabackup in the past for some other backup/server ? or is this your first time restoring with xtrabackup? Regards ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 21, 2026, 5:18am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/19 "2026-04-21T05:18:06Z")
Please find the backup & restore procedure ## Backup server:- 1)Insatall Percona software 2)Disable Crontab (crontab -u mysq1 -e) 3)create directory using mkdir Mysqlbackup command 4)xtrabackup --backup --target-dir=/backup/Mysqlbackup --parallel=4 --user=root --password=123456 5. Check /backup is mounted in new DB ## Restore SERVER 1)Insatall Percona software 2)before restore once again prepar the backup xtrabackup --prepare --target-dir=/backup/Mysqlbackup (xtrabackup --prepare --target-dir=/backup/Mysqlbackup) 3)sudo systemctl stop mysql 4)sudo rm -rf /media/vdata/mysql/\* 5)sudo xtrabackup --copy-back --target-dir=/backup/Mysqlbackup --datadir=/media/vdata/mysql 6)chown -R mysql:mysql /media/vdata/mysql 7)sudo systemctl start mysql Yes, we have done several backups & restores previously, but in this system it’s not working. For this we have formatted the operating system & checked the result being the same. ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 21, 2026, 7:57am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/20 "2026-04-21T07:57:36Z")
can you take remote & suggest what needs to be done ---
**Author:** ![viswanatha](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/viswanatha/32/23477_2.png) [@viswanatha](https://forums.percona.com/u/viswanatha)\ **Post date:** [April 22, 2026, 6:54am UTC](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621/21 "2026-04-22T06:54:30Z")
Any more suggestion from where i can pin point the exact issue [Next page](https://forums.percona.com/t/xtrabackup-restore-issue-database-not-recognized-but-mysqldump-works/40621.md?page=2)