I have encountered this error, when I tried to dump an SQL file to a database.

ERROR 1005 (HY000) at line 13: Can’t create table ’secretproject_development.canhaz’ (errno: 105)

First thing came to my mind was, to Google for an answer, where I found this. Being a lazy person to read through the whole thread, it suddenly came into my mind why that table can’t be created. There was a reference to another field in another table, and that table is not available at the moment.

Simple fix was to re-order the CREATE TABLE codes, so that tables are created before being referenced.


Comments are closed.

Return to Top