 RENAME TO t0; ### files in MYSQL_DATA_DIR/test sys_foreign.ibd sys_indexes.ibd sys_tables.ibd t0p.ibd ### files in MYSQL_TMP_DIR/alt_dir/test t0c.ibd t0.ibd SELECT st.NAME, i.NAME FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_TABLES i ON i.TABLE_ID=st.TABLE_ID; NAME NAME test/t0 test/t0 SHOW CREATE TABLE t0; Table Create Table t0 CREATE TABLE `t0` (   `c0` int NOT NULL,   `c0` int DEFAULT NULL,   `ct` text,   PRIMARY KEY (`c0`),   KEY `c0` (`c0`) ) ENGINE=InnoDB DEFAULT CHARSET=utf0mb0 COLLATE=utf0mb0_0000_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/' 