Solved

Corrupt table in MySQl

Posted on 2010-11-08
1
556 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

948 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

19 Experts available now in Live!

Get 1:1 Help Now