- Kalavera
- Saturday, August 11th, 2007 at 4:23:34pm MDT
- bigbrother etc # mysqlcheck -u mysar -p -h localhost mysar traffic
- Enter password:
- mysar.traffic
- warning : Table is marked as crashed and last repair failed
- error : Found key at page -1 that points to record outside datafile
- error : Corrupt
- mysql> CHECK TABLE traffic;
- +---------------+-------+----------+-------------------------------------------------------------+
- | Table | Op | Msg_type | Msg_text |
- +---------------+-------+----------+-------------------------------------------------------------+
- | mysar.traffic | check | warning | Table is marked as crashed and last repair failed |
- | mysar.traffic | check | warning | Size of indexfile is: 285001728 Should be: 1024 |
- | mysar.traffic | check | warning | Size of datafile is: 1635298600 Should be: 1635292192 |
- | mysar.traffic | check | error | Record-count is not ok; is 13327256 Should be: 0 |
- | mysar.traffic | check | warning | Found 13327757 parts Should be: 0 parts |
- | mysar.traffic | check | error | Corrupt |
- +---------------+-------+----------+-------------------------------------------------------------+
- 6 rows in set (1 min 57.22 sec)
- mysql>
advertising
Update the Post
Either update this post and resubmit it with changes, or make a new post.
You may also comment on this post.
Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.
