[mythtv-users] recordings disappeared from list, still exist on disk

[Robin Hill]

On Thu Nov 05, 2009 at 09:50:49PM -0500, Rod Smith wrote:

> - Database corruption. Running "mysqlcheck -r -umythtv -pyourpassword
>   mythconverg" (changing "yourpassword" to your actual password, and "mythtv"
>   to your MythTV SQL username, if necessary) should fix this problem. In
>   fact, I've got that command set up in a daily cron job to help head off
>   problems. As with full disks, symptoms can vary. I'm pretty sure I've seen
>   the "missing recordings" you describe at least a couple of times and
>   finding database corruption to be the cause.
> 
You'd be better off running the optimize_mythdb.pl script provided with
MythTV.  This uses the MythTV bindings to connect to the database
(avoiding the need to hardcode the username/password elsewhere) and does
a repair, optimize, and analyze of all tables.

Cheers,
    Robin
-- 
     ___        
    ( ' }     |       Robin Hill        <myth at robinhill.me.uk>  |
   / / )      | Little Jim says ....                            |
  // !!       |      "He fallen in de water !!"                 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091106/2d9aafc3/attachment.pgp>