Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Can't Change Table Type

forums › forums › SQLyog › Using SQLyog › Can't Change Table Type

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 2, 2007 at 6:37 pm #10160
      j_freeman
      Member

      Running MySQL 5.0.27 and SQLyog 5.22a (Community).

      In the Alter Table dialog, I click “Advanced Properties…” and then I change “Table Type” from InnoDB to MyISAM, and click OK. Then I click Alter, but I receive this error:

      Quote:
      Error No. 1071

      Specified key was too long; max key length is 1000 bytes

      Didn't change anything other than the table type. Any ideas?

    • February 4, 2007 at 6:58 am #23329
      peterlaursen
      Participant

      On MyISAM a KEY can only be 1000 bytes.  Do you use a BLOB/TEXT field for a key?  I think so!  Then you must specify a KEY lenght of max. 1000 before you can change table type.

      Do so from table context menu .. manage indexes .. edit the index

    • February 8, 2007 at 8:37 pm #23330
      j_freeman
      Member

      Ah, of course. Thanks! 🙂

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.