#--source include/innodb_page_size.inc set global innodb_compression_level = 3; CREATE TABLE t1(c1 INT, b CHAR(20)) ENGINE=INNODB PAGE_COMPRESSED=1; INSERT INTO t1 VALUES(1, 'mariadb'); echo # xtrabackup backup; let $targetdir=$MYSQLTEST_VARDIR/tmp/backup; --disable_result_log exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir; echo # xtrabackup prepare; exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.1 --prepare --export --target-dir=$targetdir; --enable_result_log --let SEARCH_PATTERN=innodb_compression_level=3 --let SEARCH_FILE=$targetdir/backup-my.cnf --source include/search_pattern_in_file.inc DELETE FROM t1; ALTER TABLE t1 DISCARD TABLESPACE; let $MYSQLD_DATADIR= `select @@datadir`; copy_file $targetdir/test/t1.ibd $MYSQLD_DATADIR/test/t1.ibd; copy_file $targetdir/test/t1.cfg $MYSQLD_DATADIR/test/t1.cfg; ALTER TABLE t1 IMPORT TABLESPACE; SELECT * FROM t1; DROP TABLE t1; set global innodb_compression_level = default; rmdir $targetdir;