Unanswered: MYSQL error #1005 can't create table - 121
I have 4.1 and am trying to run a db creation script so that I can copy a db on my portable to a remote server. This generally works! I'm using PhpMyAdmin 2.6.0 to do this. The script (which is actually being read from a file) creates the first 6 tables (about 70KB) then throws this error. I've disactivated various defaults that are set up in PhpMyAdmin, such as "Include DROP TABLE" - but can't see what's causing this. I've dropped and created this db several times - nothing changes! It gets to 6 and that's it.