一般都是迁出来, 你居然想迁进去.
参考如下命令即可

alter table t1 tablespace=innodb_system;
复制

效果图如下

(root@127.0.0.1) [db20232]> create table t1(id int primary key, name varchar(20));
Query OK, 0 rows affected (0.02 sec)

(root@127.0.0.1) [db20232]> insert into t1 values(1,'ddcw');
Query OK, 1 row affected (0.00 sec)

(root@127.0.0.1) [db20232]> alter table t1 tablespace=innodb_system;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

(root@127.0.0.1) [db20232]> show create table t1;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                        |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

(root@127.0.0.1) [db20232]> 
(root@127.0.0.1) [db20232]> system ls -ahrlt /data/mysql_3308/mysqldata/db20232/
total 20K
-rw-r-----  1 mysql mysql   67 Mar  4  2023 db.opt
drwxr-x--- 21 mysql mysql 4.0K Sep 13 14:50 ..
-rw-r-----  1 mysql mysql 8.4K Sep 13 18:07 t1.frm
drwxr-x---  2 mysql mysql   34 Sep 13 18:07 .
(root@127.0.0.1) [db20232]>
复制