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" 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: [EMAIL PROTECTED]
