[mythtv-users] Previous Recordings missing after mysqld lockup MythTv 0.19, FC4.

[Ryan Hadley]

If mysql crashes, chances are the myisam files need fixed, just like a 
filesystem often needs fixed if things aren't properly flushed before 
being shutdown.

1.  Shutdown mythfrontend/mythbackend
2.  Shutdown mysql
3.  cd /var/lib/mysql/mythconverg (usually located there... you might 
need to do a little hunting on your system... or "slocate mythconverg")
4.  myisamchk -r *.MYI
5.  Start mysql
6.  Start mythbackend/mythfrontend

And hopefully it's all back.

-Ryan

Bradley Remedios wrote:
> This morning, after having a problem with mysql and restarting the
> computer, all previously recorded shows that still had the auto-expire
> flag set never appear in the Watch Recordings interface.
>
> The jobs on those recordings are still listed in the System Status,
> along with them in the next to auto-expire listing.
>
> What steps do I need to do in order to actually view those recordings.
>  I would rather not loose them if at all possible.
>
> Below is more detailed information on what happened that resulted in this.
>
> I have been running myth on my backend for a few weeks now without
> incident.  Last night when I went to add a scheduling for a show by
> looking at the channel list it successfully added it however, when I
> went to modify the record options (from record only this showing to
> all that are aired.) mysql locked up somehow and all scheduling
> related items disappeared.
>
> Initially I thought that maybe the guide data was erroneously deleted
> so i ran mythfilldatabase but it reported that it couldn't connect to
> mysqld (which was actually still running.)
>
> So I shutdown mysqld and tried to start it up again (service mysqld
> stop / start) however it would not start up.  After rebooting the
> computer mythbackend came back up and so did mythfrontend.  I could
> also schedule new recordings even using the channel list that caused
> the problem earlier.
>
> Unfortunately, now all my previously recorded shows don't show up in
> the watch interface, but are still taking up space according to the
> auto-expire list, recording hours left and jobs in the System Status
> Interface.
>
> Thank you in advance.
> --
> Bradley Remedios
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>