partial backup includes ibdata1 big file
Bug #1632258 reported by
djay45
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Hello,
When I operate a partial backup one one database (or few tables), xtrabackup includes the ibdata1 (460Mo) in the backup whereas the database folder size is to 140ko.
Is it necessary to keep ibdata1 in the backup ? (in particular for preparing backup). I restore after individual tables ( via discard, import).
Is there an option to ignore ibdata1 file in the partial backup?
I create a bug because I had no answer to my question.
Thanks in advance,
Regards,
Jérémy
To post a comment you must log in.
Yes, it is necessary to include system tablespace in order to prepare the backup and perform the export operation. System tablespace contains undo logs which are needed to rollback incomplete transactions and change buffer which needs be to merged into the tablespaces.