XtraBackup 2.4.7 not backing up remote file per table tablespaces
Bug #1701736 reported by
Nathan Huff
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.3 |
Invalid
|
Undecided
|
Unassigned | |||
2.4 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
When a table is created with the DATA DIRECTORY option xtrabackup backs up the frm and isl files, but not the ibd file. Because it didn't back it up it also can't restore it. I have attached the output of a session showing the steps to reproduce.
To post a comment you must log in.
Thank you for the bug report.
The .ibd file was never copied during the --backup phase xtra/db. opt xtra/tx. frm xtra/tx. isl
170630 22:41:29 [01] Copying ./xtra/db.opt to /root/backup/
170630 22:41:29 [01] ...done
170630 22:41:29 [01] Copying ./xtra/tx.frm to /root/backup/
170630 22:41:29 [01] ...done
170630 22:41:29 [01] Copying ./xtra/tx.isl to /root/backup/
170630 22:41:29 [01] ...done
As expected on those files were also moved during --copy-back data/xtra/ db.opt data/xtra/ tx.frm data/xtra/ tx.isl
170630 23:08:39 [01] Copying ./xtra/db.opt to /srv/mysqldata/
170630 23:08:39 [01] ...done
170630 23:08:39 [01] Copying ./xtra/tx.frm to /srv/mysqldata/
170630 23:08:39 [01] ...done
170630 23:08:39 [01] Copying ./xtra/tx.isl to /srv/mysqldata/
170630 23:08:39 [01] ...done