[mythtv-users] no seek table

[Hika van den Hoven]

Hoi Daryl,

Thursday, October 8, 2015, 1:56:14 PM, you wrote:

> On Oct 8, 2015 7:50 AM, "Hika van den Hoven" <hikavdh at gmail.com> wrote:
>>
>> Hoi Daryl,
>>
>> Thursday, October 8, 2015, 1:11:15 PM, you wrote:
>>
>> > On Oct 8, 2015 3:27 AM, "John Pilkington" <J.Pilk at tesco.net> wrote:
>> >>
>> >> On 08/10/15 00:45, Daryl McDonald wrote:
>> >>>
>> >>> Greetings Mythizens, I'm running Myth 0.27 fixes in a 14.04 Ubuntu
>> >>> Desktop, recently I've had some freeze-ups that I worked around with a
>> >>> hard restart, this time it took two restarts one of which found errors
>> >>> and asked me to push "f" to try to fix them, I did and now I have no
>> >>> seek tables on any of my recordings, recent unedited or older already
>> >>> edited ones. What can I do now to get this back to normal?
>> >>>
>> >>> TIA  Daryl
>> >>>
>> >> $ mythutil --help
>> >> mythutil version: master [v0.28-pre-2683-g7f68683] www.mythtv.org
>> >>
>> >> Recording Utils Options:
>> >> --checkrecordings                Check all recording exist and have a
>> > seektable etc.
>> >>   --fixseektable                   (optional) fix the seektable if
>> > missing for a recording
>> >>
>> >> Don't know if this is in fixes.
>> >>
>> >> Otherwise 'mythcommflag --rebuild' individually.
>> >>
>> >> HTH, John
>> >>
>>
>> > I'll try that when I get a chance, curiously there are no seek tables
> for
>> > new recordings either, last night's.
>> > I did already optimize the db but that is done in a daily from also.
>>
>> Could it be your seektable crashed!? If so and you can not repair, you
>> have to restore from a backup or start afresh with an empty one!
>>
>> Tot mails,
>>   Hika                            mailto:hikavdh at gmail.com
>>
>> "Zonder hoop kun je niet leven
>> Zonder leven is er geen hoop
>> Het eeuwige dilemma
>> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>>
>> De lerende Mens
>>
>> _______________________________________________

> Hoi Hika, what would then happen to recordings that are post backup?

The seektable is completely recreateable as John said. It only will
take a lot af time. As I understand it is more then half of everything
in the DB. So restoring from backup might be faster. You then only
have to recreate those since that backup. 
But if it is crashed you will first have to fix it. You can check in
phpmyadmin. I probably could do it, but I've never done it, so I hope
others with more experience will step in.

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens