Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

Table './livehelp/evo_sessions' is marked as crashed and should be repaired(Errno=145)

I try to view my blog and get an error. I can't get into the database with mysql manager or with phpmyadmin. how can I fix the database?

MySQL error!

Table './livehelp/evo_sessions' is marked as crashed and should be repaired(Errno=145)

Your query:

INSERT INTO evo_sessions( sess_key, sess_lastseen, sess_ipaddress )
       
VALUES (
          "yFR58OiC6SK8CWkGxY4sMX22YqEi",
          "2008-06-23 10:31:19",
          "XXXXXX"
        )
0
JPERKS1985
Asked:
JPERKS1985
  • 2
1 Solution
 
Beverley PortlockCommented:
If you have shell access, try mysqlcheck

http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

0
 
JPERKS1985Author Commented:
How would I have it repair every table?
0
 
Beverley PortlockCommented:
mysqlcheck --repair db_name

will do all tables in a database

mysqlcheck -repair --all-databases

Will do all tables in all databases. All the info and examples you need are at
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now