Xtrabackup does not backup table structure in a readable format

[Olivier Doucet]

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://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin/exporting_importing_tables.html

[Alexey Kopytov (akopytov)]

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.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-1209