[mythtv-users] All my recording simply vanished! - database crashed!

[Michael T. Dean]

On 04/26/2008 03:16 PM, Andreas Bach Aaen wrote:
>  Lørdag den 26. April 2008 skrev Mache Creeger:
> >> mysql> select * from recorded;
> >> ERROR 145 (HY000): Table './mythconverg/recorded' is marked as
> >> crashed and should be repaired
> >>
> >>
> >> Possible more tables are affected.
> >> How can I recover this?
> >
> > # find / -name myth.rebuilddatabase.pl
> > # ~/myth.rebuilddatabase.pl

No!  Wrong script.

>  Seems a good idea. I did a: "repair table recorded;" within mysql. It
>  worked. Now I simply want to check if other less often used tables
>  has the same problem.

optimize_mythdb.pl

Might want it in a daily cronjob, too.  Read the comments/instructions 
at the top of the script.

Mike