Solved

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

Posted on 2013-02-03
2
1,065 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
[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 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

707 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