List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 27 1999 6:00pm
Subject:Re: Cannot alter, create table. Need to repair tables ???
View as plain text  
At 13:26, 19990827, Jules Bean wrote:
>>  > mysql> alter table article_types add test int;
>>  > ERROR 3: Error writing file './care/A-6.frm' (Errcode: 28)
>>  > mysql>
>> 
>> As the error message clearly indicates, you do not have enough space
>> on disk !!!!!
>
>I don't think it indicates so clearly.

MySQL comes with a command called 'perror' which translates the Errcode
into a nice string:

$ perror 28
No space left on device

I'm not sure why it doesn't just print that nice string instead of the
number.  Maybe to help out scripts which are parsing the output?  It
might be possible for 'mysql' to determine that it's being run inter-
actively and to use the human-readable error messages in that case.

Tim
Thread
Cannot alter, create table. Need to repair tables ???Christos J. Pontikis27 Aug
  • Re: Cannot alter, create table. Need to repair tables ???sinisa27 Aug
  • Re: Cannot alter, create table. Need to repair tables ???Jules Bean27 Aug
    • Re: Cannot alter, create table. Need to repair tables ???Thimble Smith27 Aug
Re: Cannot alter, create table. Need to repair tables ???Christos J. Pontikis27 Aug