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
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
mysqlcheck table test;
check | error| Table upgrade required. Please do REPAIR TABLE `test` to
fix it!
pengyao wrote:
mysqlcheck table test;
check | error| Table upgrade required. Please do REPAIR TABLE `test`
to fix it! mysqlrepair table test;
| test | repair | Warning | Incorrect string value:
| '\xBB\xA8\xBC\xE4\xC1\xBD...' for column 'test' at row 13 |
mysqlcheck table test;
check