Solved

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

Posted on 2013-02-03
2
1,034 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 142

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 28

Author Closing Comment

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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
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 video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now