Error: 150 "Foreign key constraint is incorrectly formed" when creating a new table?

Question

MariaDB

The manga_tag table already existed. But it disappeared after I tried to change the foreign key. An error occurred and the table disappeared. Now, when I try to create this table again, I get this error:

#1005 - Невозможно создать таблицу `table`.`manga_tag` (ошибка: 150 "Foreign key constraint is incorrectly formed")

When requested:

SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA ='table' AND CONSTRAINT_NAME <>'PRIMARY'

There are no keys associated with manga_tag

Answer 1

I solved the problem by exporting and importing back the entire database.