--disable_warnings drop table if exists t1; --enable_warnings CREATE TABLE t1( i serial); INSERT INTO t1 VALUES(null); --source suite/innodb/include/import.inc --echo # Flush the table and put IBD/CFG files aside for later import. FLUSH TABLE t1 FOR EXPORT; --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/t1.ibd_back --echo "copy done" --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/t1.cfg_back UNLOCK TABLES; ALTER TABLE t1 DISCARD TABLESPACE; --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/test/t1.ibd --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/test/t1.cfg ALTER TABLE t1 IMPORT TABLESPACE; INSERT INTO t1 VALUES(null); --source include/restart_mysqld.inc INSERT INTO t1 VALUES(null);