[mythtv-users] DB tables corrupt, need advice on fixing

[Jerry Rubinow]

On Mon, Oct 26, 2015 at 7:33 AM, Michael T. Dean <mtdean at thirdcontact.com>
wrote:

> On 10/26/2015 07:29 AM, Michael T. Dean wrote:
>
>>
>> https://www.google.com/search?q=mysql+Incorrect+information+in+file+.frm&ie=utf-8&oe=utf-8
>>
>> (But note that I'm not saying to follow the "Then, do the following:"
>> steps in a nice box that Google's omniscient bots have determined is all
>> you need to know to understand what happened and how to fix it.  I'm simply
>> saying that search will get you links to a lot of discussions of corrupt
>> frm files.)
>>
>
> OK, This is really bothering me.  I can understand having a "tl;dr" for
> simple well-defined/-bounded questions like, "What is Tom Hanks'
> birthday?", but for database administration?  Google should know better...
> Shame on you, Google.


Thanks Hika and Mike.   It turned out I wasn't even able to drop
mythconverg.  I had to go in and manually delete half a dozen .frm, MYI,
MYD files from the mysql directory before it would let me do that.  In the
end, I did a complete restore of the two day old backup and move the
stranded recordings to the Videos directory.  It sounds like perhaps I
could have salvaged the db at the risk of inconsistencies, but not a big
deal.

-J
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151026/622159f3/attachment.html>