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"
        )
LVL 1
JPERKS1985Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Beverley PortlockConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.