Mysql error after editing a lesson

Mysql error after editing a lesson

by Andy Diament -
Number of replies: 2
Hiya, I just spent some time editing a lesson (changing a few images)

On saving it, I got an error something like page couldn't update sad

I could not edit any lesson file sad

On looking at database with phpmyadmin, could not open mysql file mdl_lesson_pages.myi [index file] which had been corrupted

Solution: copy mdl_lesson_pages.myi and mdl_lesson_pages.myd from test version of these lessons on my laptop, manually update lesson id in several database files (due to conflict with an earlier version of the course....) and miss my lunch because the students due to use it are arriving as I type! Some recent modifications to the lessons now lost!!! Glad I had a backup...but not easy access to most recent backup!

Anyonelse had this mysql problem???????

Andy D
Average of ratings: -
In reply to Andy Diament

Re: Mysql error after editing a lesson

by Andy Diament -

Got another one on trying to log in - guess it's a server not a moodle problem;

Also learnt how to use the repair table command in my sql - saved loads of work

Andy D

Average of ratings: -
In reply to Andy Diament

Re: Mysql error after editing a lesson

by Ray Kingdon -
Yes, MySQL table corruption is very rare in my experience and myisamchk has always been able to repair the damage. It certainly helps having a very stable server platform though.
Average of ratings: -