xtrabackup restore one database to percona-server

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?

Hi dmitri;

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


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.