What's your mysql version if use mysql 3.23 , you can use mysqlcheck -r -A to repair all database. or
mysqlcheck -r webbbs if use mysql 3.22 isamchk -r abc1212.ISM to repair .ISM table myisamchk -r abc1212.MYI to repair .MYI table ----- Original Message ----- 发件人: JunSeon Oh <[EMAIL PROTECTED]> 收件人: <[EMAIL PROTECTED]> 发送时间: 2001年11月20日 13:16 主题: how to repair myisam file .? > mysql> select * from abc1212 ; > ERROR 1033: Incorrect information in file: './webbbs/abc1212.frm' > > mysql> optimize table abc1212 ; > +----------------+----------+----------+------------------------------------ -------------------+ > | Table | Op | Msg_type | Msg_text | > +----------------+----------+----------+------------------------------------ -------------------+ > | webbbs.abc1212 | optimize | error | Incorrect information in file: './webbbs/abc1212.frm' | > +----------------+----------+----------+------------------------------------ -------------------+ > > mysql> \q > > cream# cd /var/db/mysql/webbbs > cream# myisamchk abc1212 > myisamchk: error: 'abc1212' doesn't have a correct index definition. You need to recreate it before you can do a repair > cream# myisamchk -o abc1212 > myisamchk: error: 'abc1212' doesn't have a correct index definition. You need to recreate it before you can do a repair > cream# myisamchk -r abc1212 > myisamchk: error: 'abc1212' doesn't have a correct index definition. You need to recreate it before you can do a repair > > > what can i do .? > > please reply to us. > > > ------------------------------------------------------------- > Software Development Team / Manager / JunSeon Oh > Email : [EMAIL PROTECTED] > Internet total solutions - holynet (http://www.holywar.net) > ------------------------------------------------------------- > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php