SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2003
    Location
    Cambridge, UK
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error trying to add a column

    My system is WinXP Home 2002 SP1 & MySQL 3.23.47-nt.

    My main database has a couple of dozen tables, and appears to be working fine. I use OpenOffice for most tasks, and the command line to add/edit tables.

    Since yesterday, when I try to add a column (either varchar or int), I get this error message:-

    mysql> alter table organisations add column IO_gen varchar(255);
    ERROR 7: Error on rename of '.\exploitations\organisations.MYI' to '.\exploitations\#sql2-5e0-1.MYI' (Errcode: 13)

    I haven't been able to find an explanation of what this means. Can you tell me?

    Thanks, Hamish

  2. #2
    SitePoint Member
    Join Date
    Jun 2003
    Location
    Cambridge, UK
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy And I thought I'd found it

    Since posting, I have found a page in the MySQL manual which (almost) refers - A.7.1 Problems with ALTER TABLE

    Unfortunately, there are no wrongly-named files in \mysql\data to be renamed.

    Back to square 1...


Bookmarks

Posting Permissions

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