When attempting to import a database using phpMyAdmin, you may receive the error message “#1214 – The used table type doesn’t support FULLTEXT indexes”. This typically occurs when trying to import a table type that does not support FULLTEXT indexes in older versions of MySQL (e.g., 5.5).
The solution is to replace the line “ENGINE=InnoDB” with “ENGINE=MyISAM” in the SQL file that specifies the table type.
If an error occurs during import, the table that was imported halfway through remains in the database, and a duplicate error will occur if you try to import again. Therefore, delete the table that failed to import first, and then re-import.