May 22, 2012

Post: Recovering CREATE TABLE statement from .frm file

…): Table ‘test.test_innodb‘ doesn’t exist With more elaborate details in error log: 081217 15:59:11 [ERROR] Cannot find or open table test/test_innodb from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding…