[mythtv-users] empty program guide after power fauilure

Piotr lromanus at ftml.net
Mon Sep 4 18:53:19 UTC 2006


Is mysqlrepair a part of mysql package (I have mysql 4.0). I can't find
an executable with such a name on my system...

Piotr

On Mon, 2006-09-04 at 16:53 +0100, Robin Hill wrote:
> On Mon Sep 04, 2006 at 11:34:13AM -0400, Piotr wrote:
> 
> > My mythtv shows empty program guide after power failure - all entries in
> > the program grid show "unknown". The power failure affected also my
> > recordings - when I go to "Watch Recordings" the screen shows "Sorry, No
> > Recordings Available" even though I had quite a few programs recorded. 
> > 
> > I suspect that this is related to mysql database corruption but I am not
> > sure how to fix it. I don't really need the old recordings so if there
> > is a quick a easy way to wipe out everything and start from scratch I
> > would be happy to do it.
> > 
> I'd advise running mysqlrepair first (you'll probably want to check all
> databases as the main mysql database could have been corrupted as well,
> so "mysqlrepair -A" or "mysqlrepair -A -p" if you have a root mysql
> password set).  This should fix things - unless it was doing a lot of
> writing at the time of the failure then there's unlikely to be major
> corruption.
> 
> If you do need to restart from scratch then it's probably easiest to
> drop the mythconverg database, then follow the initial setup
> instructions to create a new one.
> 
> HTH,
>         Robin
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list