[mythtv-users] no editing for new recordings

[ffrr]

Milos Prudek wrote:

>MythTV suddenly stopped supporting the edit function. When I press E
>while playing new recordings, nothing happens. Old recordings (earlier
>than November 5) can be edited with E keys.
>
>I have not changed anything in Myth config within last few months. Two
>things happened just before editing stopped working for new recordings:
>- the disk run out of space and I had to kill X
>Window(Ctrl-Alt-backspace), delete files and launch X again.
>
>- a day later, my 2-year old son punched the reset button and caused
>hard reboot, with no visible consequences. Root filesystes is journal
>ReiserFS, myth storage filesystem is journal XFS.
>
>Everything except Edit seems to work fine.
>
>How should I approach this problem?
>
>  
>
>  
>

I had something similar, and one of the database tables had become 
corrupted.  I don't remember the details, but here's some notes I jotted 
down. Please note the bit at the end about backing it up first if you can.

Can check the database with
 
 mysqlcheck -u mythtv -pmythtv mythconverg

can also repair it with

 mysqlcheck -r -u mythtv -pmythtv mythconverg

but beware, this is where I got an error.  Could be a coincidence as the whole filesystem had problems and needed to be repaired at the same time.

Should have dumped the data first with

mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql