I'm getting an error when trting to update a table:
ERROR 1034: Incorrect key file for table: 'Jan04'. Try to repair it
So I ran CHECK TABLE,
What does this result mean:
mysql> CHECK TABLE Jan04 QUICK;
+---------------+-------+----------+--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+---------------+-------+----------+--------------------------------------------------------+
| logs.Jan04 | check | warning | Table is marked as crashed
|
| logs.Jan04 | check | warning | 4 clients is using or hasn't closed the table
properly |
| logs.Jan04 | check | error | Can't read key from filepos: 22400088064
|
| logs.Jan04 | check | error | Corrupt
|
+---------------+-------+----------+--------------------------------------------------------+
4 rows in set (14 min 23.80 sec)
Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
