[mythtv-users] SD grab

[Jim]

On 8/12/2014 1:22 PM, Daryl McDonald wrote:
> On Tue, Aug 12, 2014 at 1:10 PM, Gary Buhrmaster 
> <gary.buhrmaster at gmail.com <mailto:gary.buhrmaster at gmail.com>> wrote:
>
>     On Tue, Aug 12, 2014 at 4:47 PM, Daryl McDonald
>     <darylangela at gmail.com <mailto:darylangela at gmail.com>> wrote:
>     ......
>     > Database error was:
>     > Table './mythconverg/program' is marked as crashed and last
>     (automatic?)
>     > repair failed
>
>     Your mysql tables are corrupt.  You will need to repair them.
>     The optimize script will (try to) do that for you.  Usually the
>     manual repair works.
>
>     If the repair fails, you may need to restore from your backup.
>
>     Sounds like mysql was not shutdown properly before
>     you cloned the drive (whether that is due to the hardware
>     failing, a mysql bug, or a failure to stop mysql before
>     cloning the drive is not known).
>
>
> Pardon my ignorance, but where do I find the "optimize script"?
>

Also take a look on your system.

I found it in
/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
Location on your system may vary.

-- 
Jim

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140812/a38cf221/attachment.html>