Restore percona xtrabackup Dump to different database

MySQL & MariaDB
,
1

Hello we are testing percona xtrabackup for mysql 5.7.40
I have a question about the restore function.
Is it possible that for example I dump table ABC from database TEST and restore this dumpd table ABC to database TEST2?
Most of the time we dont want to override the tables we restore.

2

Hi @gruen

You can follow this blog post Percona XtraBackup: Backup and Restore of a Single Table or Database - Percona Database Performance Blog on the steps to restore single table from a full backup.

On the restore part, when you import the tablespace, all you have to do is to import it on TEST2.

1 Like