Can I restore one db from a full backup?


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?

Do you use file-per-table? If yes, see spaces.html (IMPORT TABLESPACE).

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?