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.

From https://www.percona.com/doc/percona-xtrabackup/2.4/innobackupex/restoring_individual_tables_ibk.html

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.