Solved

Corrupt table in MySQl

Posted on 2010-11-08
1
560 Views
Last Modified: 2012-05-10
We have Moodle 1.9.5 that uses MySQl 5.1 to hold its data.  We started having a problem with the lessons in Moodle and found out that one of our tables is corrupt.  Attached is the error message we see from our Moodle database page.  Our problem is that when we look at the database on our server there does not appear to be a managment gui or something of that nature to look at the table.  

How do we fix the table through Moodle or through MySql?  screenshot
0
Comment
Question by:andyseals
1 Comment
 
LVL 10

Accepted Solution

by:
laneduncan earned 500 total points
ID: 34087744
You can use the REPAIR TABLE command from within mysql.  Docs describe its usage here:
http://dev.mysql.com/doc/refman/5.1/en/repair-table.html

The short is:  use the following SQL
repair table mdl_lesson_attempts;

Do take a backup of your data first.

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

Title # Comments Views Activity
MySQL database data submission 7 69
User with DBO permission can't remotely connect 15 50
No row return after calling the fillschema method 4 46
MySQL Error Code 2 21
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

832 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