[mythtv-users] optimize_mythdb not working for remote database

Stuart Larson 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.
>
> Thanks!
> - Willy
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

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 mailing list