Xtrabackup does not backup table structure in a readable format
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Invalid
|
Undecided
|
Unassigned |
Bug Description
XtraBackup is backuping .frm files, that are not human readable.
Based on documentation, if you want to restore just one table, you have to :
1) Create the table with CREATE TABLE ...
2) Discard tablespace
3) Import tablespace
So to do step 1, you would need a readable file for the table structure (a .sql file with the CREATE TABLE statement).
Of course I can use mysqldump for this, but this is not recommended, because there could be an ALTER TABLE between my mysqldump and xtrabackup execution.
So adding an option to innobackupex to create a .sql file with the table structure just before backuping it would be really nice.
If you have another solution, please explain it in documentation more clearly here : http://
Olivier,
We have an identical feature request reported as https:/ /blueprints. launchpad. net/percona- xtrabackup/ +spec/create- table-for- exported- tables
I'm referencing this report from the BP and closing the bug as Invalid, because LP does not provide a more appropriate status.