How do we restore a single database with the restore option?

[jimmyc802]

I attempted to restore a single database by pointing to the directory of said backup. For example:

sh surrogate -c /backup/mysql/backups/daily/Mon/full_2017-12-11_2200/mysql_database

I quickly realized this would not work because of the required files in the parent directory. Which begs the question...how do we restore a single database? If that is not possible with Surrogate, what are other folks doing to solve this challenge?

[giaur500]

You can't. Percona xtrabackup does not support restoring single database. You can only restore single table, but procedure is complicated.

[roni-estein]

If anyone has ever figured this out, it would be an amazing contribution. The information is so scant, that it feels impossible to find. Using mysql 8.0.25 at the time of this writing, and if you follow the xtrabackup docs, they basically tell you it can be done, but if you put in the prepared files and restart mysql, you end up corrupted and can basically never even get to terminal where you can run ALTER TABLE ${table} IMPORT TABLESPACE;

It's quite maddening 😰