My MySQL database has partitions and they are stored in three different directories

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?

1 Like

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