Mysql Error

[manish choudhary]

Hello All,
               I have a new problem in mysql  The mysql service is running properly . but when I try to run this in the shell I get problems
when I execute this command  # mysql_upgrade

I am getting this error code

Error    : Incorrect information in file: './boredofs_orgmain/email_forms.frm'
error    : Corrupt
boredofs_orgmain.email_jobs
Error    : Incorrect information in file: './boredofs_orgmain/email_jobs.frm'
error    : Corrupt
boredofs_orgmain.email_jobs_lists
Error    : Incorrect file format 'email_jobs_lists'
error    : Corrupt
boredofs_orgmain.email_links
Error    : Incorrect information in file: './boredofs_orgmain/email_links.frm'
error    : Corrupt
boredofs_orgmain.email_list_subscriber_bounces
Error    : Incorrect information in file: './boredofs_orgmain/email_list_subscriber_bounces.frm'
error    : Corrupt
boredofs_orgmain.email_list_subscriber_events
Error    : Incorrect information in file: './boredofs_orgmain/email_list_subscriber_events.frm'
error    : Corrupt
boredofs_orgmain.email_list_subscribers
Error    : Incorrect file format 'email_list_subscribers'
error    : Corrupt
ERROR 144 (HY000) at line 507: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 509: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 516: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 519: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 522: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 528: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 531: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 534: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 537: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 543: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 546: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 549: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 552: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 558: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 564: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 566: Table './mysql/proc' is marked as crashed and last (automatic?) repair failed
FATAL ERROR: Upgrade failed

if you any idea regarding this error then reply me ASAP.



--
Thanks & Regards
Manish Choudhary (RHCE RHCSS)
Linux Administrator            
Versatile Solutions
GSM : +919909238392
www.versatilesolution.com

[nehal dattani]

Hi Manish,

If these tables are myisam engine type, try running myisamchk. if it is innodb, refer to links mentioned below.

1 ) http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html
2) http://code.google.com/p/innodb-tools/

Regards,
Nehal Dattani

--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG+un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG

--
The production of too many useful things results in too many useless people.

With best regards,
Nehal Dattani