Try using myisamchk -r option for repairing the table.
On Wed, Mar 12, 2008 at 2:53 PM, pengyao <[EMAIL PROTECTED]> wrote:
> hi,i have a question,such as:
>
> mysql> select * from test;
> ERROR 1194 (HY000): Table 'test' is marked as crashed and should be
> repaired .
>
> i think the "test" tab
pengyao wrote:
> mysql>check table test;
> check | error| Table upgrade required. Please do "REPAIR TABLE `test`"
> to fix it! mysql>repair table test;
> | test | repair | Warning | Incorrect string value:
> | '\xBB\xA8\xBC\xE4\xC1\xBD...' for column 'test' at row 13 |
> mysql>check table te
hi,i have a question,such as:
mysql> select * from test;
ERROR 1194 (HY000): Table 'test' is marked as crashed and should be repaired .
i think the "test" table was breakdown, so
mysql>check table test;
check | error| Table upgrade required. Please do "REPAIR TABLE `test`" to
fix it!
mysq
