InnoDB Table Compression The “non-strict”  behavior lets you import a  mysqldump  file into a database that does not support compressed tables, even if the source database contained compressed tables. In that case, MySQL creates the table in  ROW_FORMAT=DYNAMIC  instead of preventing the operation. To import the dump file into a new database, and have the tables re-created as they exist in the original database, ensure the server has the proper setting for the  innodb_file_per_table  configuration parameter. The attribute  KEY_BLOCK_SIZE  is permitted only when  ROW_FORMAT  is specified as  COMPRESSED  or is omitted. Specifying a  KEY_BLOCK_SIZE  with any other  ROW_FORMAT  generates a warning that you can view with  SHOW WARNINGS . However, the table is non-compressed; the specified  KEY_BLOCK_SIZE  is ignored). Level Code Message Warning 1478 InnoDB: ignoring KEY_BLOCK_SIZE= n  unless ROW_FORMAT=COMPRESSED. If you are running with  innodb_strict_mode  enabled, the combination of a  KEY_BLOCK_SIZE  with any ROW_FORMAT  other than  COMPRESSED  generates an error, not a warning, and the table is not created. Table 15.12, “ROW_FORMAT and KEY_BLOCK_SIZE Options”  provides an overview the  ROW_FORMAT and  KEY_BLOCK_SIZE  options that are used with  CREATE TABLE  or  ALTER TABLE . Table 15.12 ROW_FORMAT and KEY_BLOCK_SIZE Options Table 15.13, “CREATE/ALTER TABLE Warnings and Errors when InnoDB Strict Mode is OFF” summarizes error conditions that occur with certain combinations of configuration parameters and options 3159 Option Usage Notes Description ROW_FORMAT=REDUNDANT Storage format used prior to MySQL 5.0.3 Less efficient than ROW_FORMAT=COMPACT ; for backward compatibility ROW_FORMAT=COMPACT Default storage format since MySQL 5.0.3 Stores a prefix of 768 bytes of long column values in the clustered index page, with the remaining bytes stored in an overflow page ROW_FORMAT=DYNAMIC Store values within the clustered index page if they fit; if not, stores only a 20-byte pointer to an overflow page (no prefix) ROW_FORMAT=COMPRESSED Compresses the table and indexes using zlib KEY_BLOCK_SIZE= n Specifies compressed page size of 1, 2, 4, 8 or 16 kilobytes; implies ROW_FORMAT=COMPRESSED . For general tablespaces, a KEY_BLOCK_SIZE  value equal to the  InnoDB  page size is not permitted.