[mythtv-users] optimize_mythdb not working for remote database
halcyon at obfus.com
Thu Jan 24 19:08:46 UTC 2008
> I've searched the archives and Google, and can't seem to find relevant
> info for this.
> I've recently moved my mysql database to a separate machine to enhance
> performance (or, stop video stuttering). Now I'm noticing that my
> nightly optimize_mythdb.pl cron job is failing because it's trying to
> connect to localhost. I have MythTV working fine, my local mysql.txt
> file has "DBHostName=remotehost" at the very top, and yet it still
> pings localhost. Anyone know how to fix this? I considering editing
> the Perl script, but it looks like it leverages the Myth perl bindings
> and I have a feeling it's just a setup issue on my end of things. I
> would think it should be able to find out the correct mysql host from
> the backend or the mysql.txt file.
> - Willy
> mythtv-users mailing list
> mythtv-users at mythtv.org
optimize_mythdb.pl (at least the copy I have) - references six locations
for mysql.txt... do you have 127.0.0.1 in any that it might be finidng?
More information about the mythtv-users