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

Alter table error

forums › forums › SQLyog › Using SQLyog › Alter table error

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 14, 2003 at 4:04 am #7688
      suresh
      Member

      When I use the Alter table structure command to alter any field, the table

      change window comes up in which I can change the field name, structure etc.

      But when I press the “alter table” command button, it comes up with an error

      stating that Error number 7 – error in renaming of table “table name.myi” to

      “sql-208…” and so on with (Errorcode 13). Thereafter I have to cancel the

      window whence it says “you will lose changed structure ” and I have to say

      “OK” to come out. Thus I am unable to change the structure of any table.

      I am using MySQL ver 3.23.55 and latest version of SQLYog downloaded

      recently on a Windows XP professional system.

    • February 15, 2003 at 4:59 pm #13724
      Ritesh
      Member

      Sorry for the late reply :ph34r:

      You probably have a permissions issue in your data or temp directory…Mysql is not able to create a temporary table when making the table alteration.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.