1set global innodb_compression_level = 3;
2CREATE TABLE t1(c1 INT, b CHAR(20)) ENGINE=INNODB PAGE_COMPRESSED=1;
3INSERT INTO t1 VALUES(1, 'mariadb');
4# xtrabackup backup
5# xtrabackup prepare
6FOUND 1 /innodb_compression_level=3/ in backup-my.cnf
7DELETE FROM t1;
8ALTER TABLE t1 DISCARD TABLESPACE;
9ALTER TABLE t1 IMPORT TABLESPACE;
10SELECT * FROM t1;
11c1	b
121	mariadb
13DROP TABLE t1;
14set global innodb_compression_level = default;
15