Justin Sickles

MySQL Error Debugging Assistance

Got to remember this little MySQL snippet:

SHOW ENGINE INNODB STATUS

Many times, I’ll get an obscure MySQL error “General error: 1215 Cannot add foreign key constraint”. The above snippet, when run on the same database, gives a block of text which includes the section “LATEST FOREIGN KEY ERROR” – a MUCH more detailed and informative error message!