Re: FK problem: ibd file does not currently exist

[Neil Bacon]

Thanks for the "SHOW INNODB STATUS" hint.

mysqldump dbname > all.sql
showed that the table referenced by my foreign key was a MyISAM table, not a InnoDB table.

To fix it, in all.sql I:
- globally substituted "InnoDB" for "MyISAM";
- added "SET FOREIGN_KEY_CHECKS=0;" at the top
- added "SET FOREIGN_KEY_CHECKS=1;" at the bottom
Then I recreated the database with:
mysql dbname < all.sql

I still don't have any .idb file (mentioned in the "SHOW INNODB STATUS" error message), but its fixed.