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

ALTER TABLE ISSUE

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › ALTER TABLE ISSUE

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 17, 2003 at 8:41 am #7694
      cgodfroid
      Member

      Good morning,

      First of all congratulations for your tool … great !

      I encounter the following problem, trying to alter one table:

      I try to add one column at the end of an existing table, already populated with some values. This column is called 'ACTIVE_FLAG' and is of type char(1) not null default value = 'Y'. Having added this column I try to save my changes by clicking on 'Alter table” and I get the following message:

      Error No. 7

      Error on rename of '.vetnetveterinary.MYI' to '.vetnet#sql2-204-3.MYI' (Errcode:13)

      Could someone help ? Or I will have to get back on the old fashioned way of altering tables 🙁

      Thank you all.

      Chris.

      😮

    • February 17, 2003 at 12:12 pm #13750
      CalEvans
      Member

      Check 2 things:

      1: Look in the History tab and see what is actually being executed. Copy it and past it into the command line mysql client. See if it works. Report back.

      2: Check the permission on the directory vetnet. Does whatever user that mysql is running as have permission to write to this dir?

      =C=

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