phpMyAdmin #1005 errno: 150 error code
I am trying to import MySQL code into phpMyAdmin.
The above is the error code which I am getting. I have googled and it suggests it's a foreign key constraint error.
#1005 - Can't create table 'dbname.test_table' (errno: 15
I am reading this article, trying to troubleshoot. http://verysimple.com/2006/10/22/mys...frm-errno-150/
- All tables use INNODB engine.
- I have re-ordered my tables (it has created the first few tables which require no foreign keys successfully)
Is it wrong to have a foreign key in my members type table called memberID and also to have the primary key in my members table called memberID. Could this be why it is not importing when I list the constraint like this...
CONSTRAINT member_fk FOREIGN KEY (`member_id`) REFERENCES members (`member_id`)