So I’m dumping a database on a remote server to pull down to my local box to do some development. When loading the mysqldump file I encountered the error:
ERROR 1005 (HY000) at line 8680: Can't create table 'database.table' (errno: 150)
After doing some searching online it seems that is one of the notoriously cryptic MySQL error messages that is woefully overloaded.
I did manage to fix the error (which ended up being a foreign key reference from another table to the one that was erroring out whereby the column definitions were not exactly the same) and learned two important things: