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 !

pengyao
2008-03-12

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 test;
> check | error | Table upgrade required. Please do "REPAIR TABLE `test`"
> to fix it!

- Did you upgrade from 4.0 to 5.x ?
- did you copy the datadir from some other box

>
> what i can do?
> Thanks for your !
>
>
pengyao
>
2008-03-12

--
raj shekhar
facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog
Yoda of Borg are we: Futile is resistance. Assimilate you, we will
'Borg? Sounds Swedish.' - Lily, Star Trek First Contact

Try using myisamchk -r option for repairing the table.


On Wed, Mar 12, 2008 at 2:53 PM, pengyao <xweiyao@gmail.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 !
>
>
> 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: prajapatikc@gmail.com