Hi, we have following scenario. We have taken a full backup of MySQL 8 database from MySQL server A with xtrabackup and there is another MySQL 8 server B which has different databases on them, now we would like to restore a single database from MySQL A server full backup to MySQL B server, is it possible? is there any blogs for it?
This guide outlines the process of backing up and restoring a single table or an entire database schema using Percona XtraBackup.
This documentation from Percona provides instructions for restoring individual tables in a partial backup to a server.
Also, you can check it out: