Hi,

perror 28
Error code  28:  No space left on device

Make some space on your hard disk ;)

Regards,
  Jocelyn
----- Original Message -----
From: "tl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 10:55 AM
Subject: Repair TABLE - OPERATION FAILED


> Hello,
> Please help me.
>
> mysql> repair table none;
> +----------------+--------+----------+-----------------------------+
> | Table          | Op     | Msg_type | Msg_text                    |
> +----------------+--------+----------+-----------------------------+
> | n_toccata.none | repair | error    | 28 when writing to datafile |
> | n_toccata.none | repair | error    | 28 when writing to datafile |
> | n_toccata.none | repair | status   | Operation failed            |
> +----------------+--------+----------+-----------------------------+
> 3 rows in set (0.14 sec)
>
>
> mysql> select * from none limit 12;
> ERROR 1016: Can't open file: 'none.MYD'. (errno: 144)
> mysql> check table none;
>
+----------------+-------+----------+---------------------------------------
------------------+
> | Table          | Op    | Msg_type | Msg_text
|
>
+----------------+-------+----------+---------------------------------------
------------------+
> | n_toccata.none | check | warning  | Table is marked as crashed and last
repair failed       |
> | n_toccata.none | check | warning  | Size of indexfile is: 309248
Should be: 35840      |
> | n_toccata.none | check | error    | Size of datafile is: 2809856
Should be: 2809916 |
> | n_toccata.none | check | error    | Corrupt
|
>
+----------------+-------+----------+---------------------------------------
------------------+
> 4 rows in set (0.00 sec)
>
>
>
> Thank's very much.
>
> Alvydas
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to