Hi , my MySQL database has multiple partitions and those are stored in multiple different directories. Would it still be possible to use xtrabackup to backup my database and for it to contain all the data from all those different directories?
Hello, it should work fine.
During backup, xtrabackup will copy them to backupdir/dbname. It will also save remote tablespaces location in xtrabackup_tablespaces file.
on copy-back/ move-back, it will move the remote tablespaces from backup dir to remote location
Thank you so much. Would definitely give this a go