Can I restore one db from a full backup?

MySQL & MariaDB Percona XtraBackup
1

Hello,

I’m wondering if it’s possible to restore a single database from a prepared full backup or is my only option for this granularity to backup each db individually?

2

Do you use file-per-table? If yes, see http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-table spaces.html (IMPORT TABLESPACE).

3

Yes our MySQL servers are configured with the innodb_file_per_table setting. We also support or have myisam databases on our MySQL servers. Is it possible to restore a single db from a full innobackupex?