https://stackoverflow.com/questions/75090681/restore-table-from-frm-and-ibd-file

mariadb-10.6-12-56c9b0bca05

MariaDB [test]> create table t1 (i double);
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> insert into t1 values (20.50);
Query OK, 1 row affected (0.001 sec)

MariaDB [test]> select * from t1;
+------+
| i    |
+------+
| 20.5 |
+------+
1 row in set (0.000 sec)

MariaDB [test]> create table t2 like t1;
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> alter table t2 discard tablespace;
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> FLUSH TABLES test.t1 FOR EXPORT;
Query OK, 0 rows affected (0.001 sec)

/tmp/build-mariadb-server-10.6-test-datadir/test 
$ cp t1.cfg t2.cfg

/tmp/build-mariadb-server-10.6-test-datadir/test 
$ cp t1.ibd t2.ibd


MariaDB [test]> lock tables t2 write;
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> alter table t2 import tablespace;
Query OK, 0 rows affected (0.002 sec)

MariaDB [test]> select * from t2;
+------+
| i    |
+------+
| 20.5 |
+------+
1 row in set (0.001 sec)