InnoDB 1.1 for MySQL 5.5 User’s Guide (Early Adopter Release) :: 11 Downgrading the InnoDB Storage Engine :: 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 storage engine, 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 storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .
