--source include/have_innodb.inc --let $MYSQLD_DATADIR= `SELECT @@datadir` --let $SOURCE_IBD=`SELECT CONCAT("$MYSQLD_DATADIR", "test/t1.ibd")` --let $TARGET_IBD=`SELECT CONCAT("$MYSQLD_DATADIR", "test/imp_t1.ibd")` --disable_abort_on_error SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' ; SET DEFAULT_STORAGE_ENGINE= 'InnoDB' ; # SET GLOBAL default_storage_engine = 'InnoDB' /* RQG runner */; CREATE TABLE `t1` ( `col_int` int, `col_text` text, `col_varchar_255` varchar(255)) ENGINE=innodb ; INSERT INTO t1 VALUES (6, 'cow', 'j') , (NULL, 'electric', 'r') , (7, 'world', 'r') , (1, 'jail', 'functional') , (345178112, 'yeah', 'q') , (-144769024, 'hell', 'word') , (NULL, 'violent', 'v') , (3, 'surface', 'plus') ; FLUSH TABLES t1 FOR EXPORT ; UNLOCK TABLES ; CREATE TABLE imp_t1 LIKE t1 ; ALTER TABLE imp_t1 ENGINE = InnoDB ROW_FORMAT = REDUNDANT ; ALTER TABLE imp_t1 DISCARD TABLESPACE ; --echo 'copy ibd file around' --copy_file $SOURCE_IBD $TARGET_IBD ALTER TABLE imp_t1 IMPORT TABLESPACE ; # [ 'Import_3', '#3 .+#4 rec_get_bit_field_1.+#5 rec_get_deleted_flag.+#6 PageConverter::update_records.+#7 .{1,20}in PageConverter::update_index_page.+#8 .{1,20}in PageConverter::update_page.+#9 .{1,20}in PageConverter::operator.+#10 .{1,20}in fil_iterate.+#11.{1,20}fil_tablespace_iterate.+#12 .{1,20}in row_import_for_mysql.+#13 .{1,20}in ha_innobase::discard_or_import_tablespace' ], DROP TABLE imp_t1, t1;