Solved

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

Posted on 2008-06-23
5
312 Views
Last Modified: 2013-12-12
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
Comment
Question by:JPERKS1985
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 34

Expert Comment

by:Beverley Portlock
ID: 21847347
If you have shell access, try mysqlcheck

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

0
 
LVL 1

Author Comment

by:JPERKS1985
ID: 21915724
How would I have it repair every table?
0
 
LVL 34

Accepted Solution

by:
Beverley Portlock earned 500 total points
ID: 21916026
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question