Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Suppose I want to recover a table which does not exist anymore from an old physical backup. With MyISAM it's amazingly easy, but with InnoDB I need to re-create an empty table first, and maybe I don't know the table definition.
So, would it be possible to make SHOW CREATE TABLE work even if "table doesn't exist in engine"? I hope that .frm contains sufficient information to do this.