include table definition information (CREATE TABLE) for exported tables

Bug #1027172 reported by Swany on 2012-07-20
6
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

It is possible to export/import tables, or to recover only a subset of tables using Xtrabackup. In order to use a table which has been exported by Xtrabackup, ALTER TABLE {DISCARD|IMPORT} TABLESPACE is required, which requires an empty table definition.

In a disaster recovery situation (such as a dropped table), the original CREATE TABLE statement may not be available.

I suggest that during the backup phase when .frm files are copied, to also collect CREATE TABLE statements for the tables that are being backed up, and write them out to a single metadata file (xtrabackup_table_metadata maybe).

The metadata file can then be used to restore the table definition before calling ALTER TABLE ... TABLESPACE.

--Justin

Alexey Kopytov (akopytov) wrote :
Changed in percona-xtrabackup:
status: New → Invalid

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers