June 20, 2013

Post: Recovering CREATE TABLE statement from .frm file

…] Cannot find or open table test/test_innodb from the internal data dictionary of InnoDB though the .frm file for the table exists… TABLE test_myisam USE_FRM, however it does not work… just yet. You need to create the .MYI and .MYD files for the table to make it work: [root@test3 test]# touch test_myisam.MYI [root@test3 test]# touch test_myisam.MYD