From: Krishna Chandra Prajapati (prajapatikcgmail.com)
Date: Thu Mar 13 2008 - 01:41:22 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Try using myisamchk -r option for repairing the table.

On Wed, Mar 12, 2008 at 2:53 PM, pengyao <xweiyaogmail.com> 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" table was breakdown, so
>
> 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 test;
> check | error | Table upgrade required. Please do "REPAIR TABLE `test`"
> to fix it!
>
> what i can do?
> Thanks for your help!
>
>
> pengyao
>
> 2008-03-12
>

--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapatikcgmail.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]