I'm using percona xtrabackup to do full DB backups on mariadb 10 and now i'm testing the restore.
I want to restore just some databases (the important DBs) and ignore others (big archive DBs), simulation a total DB lost to check how much time i would take to restore the most important stuff to get business resume. Tying to recover everything would take much longer as the archives are not critical and could be recovered later.
The problem is (AFAIK) xtrabackup seems to only support full restores.
So is there any way to do a partial restore (only restore some DBs) with xtrabackup, using a full xtrabackup backup
Thanks
0 Answers