[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