[mythtv-users] Lost all scheduled recordings

[Michael T. Dean]

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