Create table without index, foreign key and data.
ALTER TABLE [table] DISCARD TABLESPACE;Copy [table].ibd to database dir.
ALTER TABLE [table] IMPORT TABLESPACE;Add table index and done.
Note: must be same mariadb version.
Create table without index, foreign key and data.
ALTER TABLE [table] DISCARD TABLESPACE;Copy [table].ibd to database dir.
ALTER TABLE [table] IMPORT TABLESPACE;Add table index and done.
Note: must be same mariadb version.