The built-in InnoDB in MySQL can only open tables that were created in
REDUNDANT or COMPACT format. Starting with MySQL version
5.0.21, an attempt to open a table in some other format results
in ERROR 1146 (42S02): Table
'.
Furthermore, a message “test.t' doesn't existunknown table
type” appears in the error log.
In the InnoDB Plugin, you may rebuild an incompatible table by
issuing a statement ALTER TABLE
.
table_name
ROW_FORMAT=COMPACT
This is the User’s Guide for InnoDB Plugin 1.0.8 for MySQL 5.1, generated on 2012-02-14 (revision: 28615) .
