[mythtv-users] database problem

Michael T. Dean mtdean at thirdcontact.com
Fri Jan 25 03:21:20 UTC 2008


On 01/24/2008 10:08 PM, steve wrote:
> Michael T. Dean wrote:
> | On 01/24/2008 09:21 PM, Dean Harding wrote:
> |> steve wrote:
> |>
> |>> any advice would be appreciated.  thanks.
> |>>
> |> I would try executing "CHECK TABLE settings" in mysql and if there are
> |> any errors, "REPAIR TABLE settings" (might be a good idea to run
> |> optimize_mythdb.pl if the settings table is corrupted).
> |
> | I recommend just using optimize_mythdb.pl, instead.
> |
>
> ok, ran the optimize script, and got this.
>
> steve at steve-desktop:/usr/share/doc/mythtv-backend/contrib$ sudo
> /etc/init.d/mysql restart
> ~ * Stopping MySQL database server mysqld
> ~ [ OK ]
> ~ * Starting MySQL database server mysqld
> ~ [ OK ]
> ~ * Checking for corrupt, not cleanly closed and upgrade needing tables.
> steve at steve-desktop:/usr/share/doc/mythtv-backend/contrib$ sudo sh
> optimize_mythdb.pl
> optimize_mythdb.pl: 14: use: not found
> optimize_mythdb.pl: 17: Syntax error: word unexpected (expecting ")")
> steve at steve-desktop:/usr/share/doc/mythtv-backend/contrib$

It's not a shell script.  It's a Perl script--and it's executable.  Just
use ./optimize_mythdb.pl (or execute with "perl -w" or whatever).  Oh,
and you don't need to be root--just need to be able to connect to the DB
as the mythtv DB user.

Mike


More information about the mythtv-users mailing list