CREATE TABLE t1(a int PRIMARY KEY) COMPRESSION='zlib'; ERROR HY000: Compression failed with the following error : Punch hole not supported by the filesystem or the tablespace page size is not large enough. CREATE TABLE t1(a int PRIMARY KEY); ALTER TABLE t1 DISCARD TABLESPACE; # copy unzipped .ibd and .cfg ALTER TABLE t1 IMPORT TABLESPACE; ERROR HY000: Schema mismatch (Compression option does not match) # Manually remove tablespace files, since import failed and drop won't delete them. DROP TABLE t1;