<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Sun, Jan 28, 2018 at 4:45 PM, Craig Huff <span dir="ltr"><<a href="mailto:huffcslists@gmail.com" target="_blank">huffcslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div class="gmail-h5"><div class="gmail_extra"><div class="gmail_quote">On Sun, Jan 28, 2018 at 4:17 PM, Craig Huff <span dir="ltr"><<a href="mailto:huffcslists@gmail.com" target="_blank">huffcslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div class="gmail-m_-984281896323703262gmail-h5"><div class="gmail_extra"><div class="gmail_quote">On Sun, Jan 28, 2018 at 4:09 PM, Craig Huff <span dir="ltr"><<a href="mailto:huffcslists@gmail.com" target="_blank">huffcslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><span><div class="gmail_extra"><div class="gmail_quote">On Sun, Jan 28, 2018 at 4:00 PM, Paul Harrison <span dir="ltr"><<a href="mailto:mythtv@sky.com" target="_blank">mythtv@sky.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"><div><div class="gmail-m_-984281896323703262gmail-m_7620960876218316379m_6733518125825962791h5"><br></div></div>
If you can't repair the recordedseek table one option is to truncate
it and restore just that table from your old backup. That way only
the seektables for new recordings will be missing which you can fix
by running 'mythutil --checkrecordings --fixseektable'<br>
<br>
Paul H.<br>
</div>
<br></blockquote></div><br></div></span><div class="gmail_extra">Paul-<br><br></div><div class="gmail_extra">Re-creating the seektable data for the new recordings it what I was hoping to do, but the trick I haven't figured out yet is how to restore just the recordedseek table.<br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Can you give me more details on that?<br><ul><li>How do I truncate it (presumably the recordedseek table)?</li><li>How would you suggest I restore the recordedseek table from the backup?</li></ul></div><div class="gmail_extra">--<br></div><div class="gmail_extra">Craig.<br></div></div>
</blockquote></div><br></div></div></div><div class="gmail_extra">Looks like truncation would involve launching an interactive mysql session and invoking the command "TRUNCATE TABLE recordedseek;". Correct?<br><br>--<br></div><div class="gmail_extra">Craig.<br></div></div>
</blockquote></div><br></div></div></div><div class="gmail_extra">Sadly, it looks like I'll have to be more crude about rebuilding the missing seektable data since my mythutil doesn't support either of the command options <span>--checkrecordings or --fixseektable.<br><br>On my system, "mythtv --version" reports:<br></span>MythTV Version : v0.27.6-28-g6fb800d<br>MythTV Branch : fixes/0.27<br><br></div><div class="gmail_extra">Once how to restore just the recordedseek table is established, I think I can manage the rest.<br></div><div class="gmail_extra"><div><br>--<br></div>Craig.</div></div>
</blockquote></div><br></div><div class="gmail_extra">I'm hoping there's a smarter way than either of the options I've come up with for restoring just the recordedseek table from the latest backup. I have though of these:<br><ol><li>Make a copy of the backup file and delete all the table structure and data dump records for the other tables, leaving just the ones for the recordedseek table, and then use that with the <a href="http://mythconverg_restore.pl">mythconverg_restore.pl</a> script.</li><li>Make a copy of /var/lib/mysql/mythconverg in another directory, do a full restore using <a href="http://mythconverg_restore.pl">mythconverg_restore.pl</a>, and then copy back all the files from the other directory except the recordedseek table files.</li></ol></div><div class="gmail_extra">Anyone have a better solution?<br><br>--<br></div><div class="gmail_extra">Craig.<br></div></div>