?
Solved

MySQL crash :Table './Mydb/jos_session' is marked as crashed and should be repaired

Posted on 2013-02-03
2
Medium Priority
?
1,244 Views
Last Modified: 2013-02-03
Hi,
one of my Joomla sites has crashed with the following error message:


Table './Mydb/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('m8evkv79sb7uq2hefjn1l8ent1', 0, '1359911452')

ANy ideas (without losign data :-)
0
Comment
Question by:chilternPC
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 38848950
Please run this statement
REPAIR TABLE jos_session;

Against your database
0
 
LVL 29

Author Closing Comment

by:chilternPC
ID: 38849003
thank you - it fixed it.
any idea how it got broke?
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month17 days, 5 hours left to enroll

864 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