[mythtv-users] Lost all scheduled recordings

[Matt Rude]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thanks Mike the optimize_mythdb.pl worked.

Matt

Michael T. Dean wrote:
> On 07/07/2006 01:07 AM, Matt Rude wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> I have but I don't know the what the results should be.
>> here it is:
>> [root at mythtv log]# mysqlcheck
>> - --- snip ---
>> - --------------------------------- -----------------------------
>> all-databases                     FALSE
>> all-in-1                          FALSE
>> auto-repair                       FALSE
>> character-sets-dir                (No default value)
>> compress                          FALSE
>> databases                         FALSE
>> default-character-set             latin1
>> fast                              FALSE
>> force                             FALSE
>> extended                          FALSE
>> host                              (No default value)
>> port                              0
>> quick                             FALSE
>> silent                            FALSE
>> socket                            (No default value)
>> ssl                               FALSE
>> ssl-key                           (No default value)
>> ssl-cert                          (No default value)
>> ssl-ca                            (No default value)
>> ssl-capath                        (No default value)
>> ssl-cipher                        (No default value)
>> user                              (No default value)
>> use-frm                           FALSE
>
> You do realize that you just "snipped" the usage information that
> describes how to /properly/ execute the mysqlcheck command and that's
> printed because you didn't properly execute the mysqlcheck command.
>
> Anyway, just run optimize_mythdb.pl from the contrib directory (and set
> it up as a daily cron job).  It fixes up the database for you and
> doesn't require you to learn to use it.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFErfFk6mAOzLDAOE0RAsO9AKCKLt8mk7Q4LSmbA4ra1a2wZMDPOwCfTQMG
hhVRB6QB9sX6tWW22czKlGw=
=54Ni
-----END PGP SIGNATURE-----