Restroing Database on existing MySQL server which has other databases

MySQL & MariaDB
1

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?

2

Hey @ahmadzadaa
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:

2 Likes