<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<br>
<div class="moz-cite-prefix">On 28/01/18 22:17, Craig Huff wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAO0hLGoQanMhyv869A2gygAnCYX3Zza5TAWLqFtKog_k=SZrjg@mail.gmail.com">
<div dir="ltr">
<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"
moz-do-not-send="true">huffcslists@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><span class="">
<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"
moz-do-not-send="true">mythtv@sky.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0
0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>
<div class="m_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 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>
<br>
</blockquote>
<br>
Yes that will remove all the data from the recordedseek table. I
would also drop the table as well since the backup will recreate it.<br>
<br>
Your backup will contain all the data for all tables so you will
have to create a new one with just the recordedseek data in it.
That's the tricky bit because if you have a lot of recordings the
backups are very large. You can if they are small enough edit it in
a text editor but most are to large to do that.<br>
<br>
Easiest way is probably to run a sed command to extract it something
like this works for me<br>
<pre class="lang-sql prettyprint prettyprinted" style=""><code><span class="pln">sed -n -e '/CREATE TABLE.*`recordedseek`/,/UNLOCK TABLES;/p' mythconverg-1348-20171215001052.sql > recordedseek.sql</span><span class="pln">
Paul H.</span><span class="pun"></span></code></pre>
</body>
</html>