InnoDB Plugin 1.0 for MySQL 5.1
(Early Adopter Release) User’s Guide :: 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 Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
