xtrabackup restore one database to percona-server

MySQL & MariaDB Percona XtraBackup
1

there is a server with several databases, on crowns are made database backups, separately for each database:
/usr/bin/xtrabackup --defaults-file=/etc/mysql/my.cnf --user=‘root’ --password=‘password’ --datadir=/var/lib/mysql --databases “$DATABASE” --target-dir=$BACKUP_DIR/$DATABASE --backup 2>&1

you need to restore one database without changing others, how to do this?

2

Hi dmitri;

The below guide walks you through the backup/prepare/restore process for a partial backup:

[url]https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/partial_backups_innobackupex.html[/url]

If you’re trying to restore a single database back into an existing server with other existing databases, then you’ll basically be restoring the individual tables.