InnoDB 1.1 for MySQL 5.5 User’s Guide (Early Adopter Release) :: 4 InnoDB File Format Management :: 4.6 Downgrading the File Format
Section Navigation [Toggle]
Each InnoDB tablespace file (with a name matching
*.ibd) is tagged with the file format used to
create its table and indexes. The way to downgrade the tablespace
is to re-create the table and its indexes. The easiest way to
recreate a table and its indexes is to use the command:
ALTER TABLEtROW_FORMAT=COMPACT;
on each table that you want to downgrade. The COMPACT row format
uses the file format “Antelope”. It was introduced in MySQL
5.0.3.
This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .
