Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Unanswered: MYSQL error #1005 can't create table - 121

    Hi,

    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.

    Any ideas?
    Tks
    Pru

  2. #2
    Join Date
    Oct 2006
    Posts
    2
    Sorry, just figured out it's something to do with some tables being InnoDB and some MyISAM - have no idea why that is, but when I change them all to MyISAM, it works fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •