tl,
Friday, October 11, 2002, 11:55:41 AM, you wrote:
t> mysql> repair table none;
t> +----------------+--------+----------+-----------------------------+
t> | Table | Op | Msg_type | Msg_text |
t> +----------------+--------+----------+-----------------------------+
t> | n_toccata.none | repair | error | 28 when writing to datafile |
t> | n_toccata.none | repair | error | 28 when writing to datafile |
t> | n_toccata.none | repair | status | Operation failed |
t> +----------------+--------+----------+-----------------------------+
t> 3 rows in set (0.14 sec)
t> mysql> select * from none limit 12;
t> ERROR 1016: Can't open file: 'none.MYD'. (errno: 144)
t> mysql> check table none;
t>
+----------------+-------+----------+---------------------------------------------------------+
t> | Table | Op | Msg_type | Msg_text
|
t>
+----------------+-------+----------+---------------------------------------------------------+
t> | n_toccata.none | check | warning | Table is marked as crashed and last repair
failed |
t> | n_toccata.none | check | warning | Size of indexfile is: 309248 Should be:
35840 |
t> | n_toccata.none | check | error | Size of datafile is: 2809856 Should
be: 2809916 |
t> | n_toccata.none | check | error | Corrupt
|
t>
+----------------+-------+----------+---------------------------------------------------------+
t> 4 rows in set (0.00 sec)
Your table was not repaired because you have not enough space
$ perror 28
Error code 28: No space left on device
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
