[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: 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.
More information about the mythtv-users