I have a 3 node Mariadb Galera cluster running. Each node is running Mariadb 10.2.15 (mysql Ver 15.1 Distrib 10.2.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) with Xtrabackup version 2.4.11 (based on MySQL server 5.7.19 Linux (x86_64) (revision id: b4e0db5) )
I've read that with xtrabackup I can backup and restore individual tables, which is functionality that I need in the event one of my clients hoses a table and needs it restored from backup. However, it appears that restoring individual tables (and pretty much anything else) is to be done on a new server that doesn't have that table/db/etc.
Importing tables To import a table to other server, first create a new table with the same structure as the one that will be imported at that server:
then discard its tablespace:
After this, copy mytable.ibd and mytable.exp ( or mytable.cfg if importing to MySQL 5.6) files to database’s home, and import its tablespace:
So if I'm restoring to the same server and not a different server, would I have to delete that tablespace, re-create it, then restore it or is there a less convoluted way of doing this?