[mythtv-users] Can't find settings.frm

[Mike Perkins]

John Haywood wrote:
> I'm trying to track down an issue with mythfilldatabase not running, so 
> I thought the db itself might be implicated.
> 
> On running optimize_mythdb.pl, I get the following error:
> 
> DBD::mysql::st execute failed: Can't find file: 
> './mythconverg/settings.frm'
> 
> OK, lessee
> 
> less /etc/my.conf
> 
> [mysqld]
> datadir=/var/lib/mysql
> 
> OK, dig a bit:
> 
> ls -la /var/lib/mysql/mythconverg/settings.frm
> -rw-rw---- 1 mysql mysql 8630 2009-07-05 22:57 
> /var/lib/mysql/mythconverg/settings.frm
> 
> Its in the right place, owner/group seem good, permissions too
> 
> Anybody run into this one before?
> 
Why are you running optimize_mythdb.pl as your mysql user? Shouldn't you be 
running it as your mythtv (backend) user?

-- 

Mike Perkins