<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 28/01/18 21:14, Craig Huff wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAO0hLGoJdgQk5UgKkGSL0_NA=Avy0JmV2-urWnxHhpvrw5ouVQ@mail.gmail.com">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">On Sun, Jan 28, 2018 at 3:03 PM, John
Pilkington <span dir="ltr"><<a
href="mailto:J.Pilk@tesco.net" target="_blank"
moz-do-not-send="true">J.Pilk@tesco.net</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">Restore from earlier
backup?<br>
<br>
</blockquote>
</div>
<br>
</div>
<div class="gmail_extra">I found an earlier message on the
mailing list by Michael Dean from last February that pointed
to a web link for myisam table maintenance. The simple table
check reported the same table with the same symptom, along
with one named #sql-5de_e6a.MYI as corrupted. I suspect the
latter file is a mysql internal table and do not plan to touch
it. As for the recordedseek table, the next step is to use
myisamchk to attempt a repair on it using the "easy safe
repair" step.</div>
</div>
</blockquote>
<br>
Maybe unrelated... but.... I get issues with that sort of table name
when mysql tmp disk space runs out.<br>
My tmpdir in /etc/mysql/my.cnf was pointing to /tmp<br>
<br>
[root@mythtv ~]# grep tmpdir /etc/mysql/my.cnf<br>
tmpdir = /tmp<br>
<br>
I pointed it at<br>
tmpdir = /myth/tmp/<br>
<br>
That resolved the issue... until /myth mount point gets low :-)<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a class="moz-txt-link-abbreviated" href="mailto:stinga+mythtv@wolf-rock.com">stinga+mythtv@wolf-rock.com</a> o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------</pre>
</body>
</html>