InnoDB Plugin 1.0 for MySQL 5.1
(Early Adopter Release) User’s Guide :: 11 Downgrading from the InnoDB Plugin :: 11.4 Possible Problems :: 11.4.1 Accessing COMPRESSED or DYNAMIC Tables
Section Navigation [Toggle]
- 11.4 Possible Problems
- 11.4.1 Accessing COMPRESSED or DYNAMIC Tables
- 11.4.2 Issues with UNDO and REDO
- 11.4.3 Issues with the Doublewrite Buffer
- 11.4.4 Issues with the Insert Buffer
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.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
