The built-in InnoDB in MySQL can access only tables in the “Antelope” file
format, that is, in the REDUNDANT or COMPACT row format. If
you have created tables in COMPRESSED or DYNAMIC format, the
corresponding tablespaces in the new “Barracuda” file format,
and it is necessary to downgrade these tables.
First, identify the tables that require conversion, by executing this command:
SELECT table_schema, table_name, row_format
FROM information_schema.tables
WHERE engine='innodb'
AND row_format NOT IN ('Redundant', 'Compact');

User Comments
Add your own comment.