[mythtv-users] Anyway to have mythbackend and mysql server on different machines?

Listbox listbox at hymerfania.com
Tue Dec 19 01:20:51 UTC 2006

Thanks folks!
I grepped for "/mysql.txt" in the sources, and came up with:
./contrib/optimize_mythdb.pl:    my @mysql =
./contrib/optimize_mythdb.pl:                 '/usr/share/mythtv/mysql.txt',
./contrib/optimize_mythdb.pl:                 '/etc/mythtv/mysql.txt',

The path that was correct for me was "/usr/share/mythtv/"
I created that file to point to my mysql server, and I was golden!

By the way, the docs in the mythtv 20 source directory are inconsistent with
my installation, there is no /usr/local/share/mythtv directory. 
I installed from the ATRmpms repository, I have no idea if that makes a


-----Original Message-----
From: Rich West [mailto:Rich.West at wesmo.com] 
Sent: Monday, December 18, 2006 10:55 AM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Anyway to have mythbackend and mysql server on
different machines?

Kevin Kuphal wrote:
> Listbox wrote:
>> Hi,
>> I'd like to have mythbackend use a remote mysql server, instead of 
>> using a local socket file.
>> I've discovered that setting ~/.mythtv/mysql.txt only works for the 
>> frontend. If mysql is not running on the same machine, then 
>> mythbackend fails when it looks for the "socket file", and refuses to 
>> start.
>> Is there an equivalent to "mysql.txt" for mythbackend, or any other 
>> way to specify a remote mysql server?
> Can't you just run mythtv-setup on that system and change the database 
> parameters?
Just make sure that the local mysql server is down when you run mythsetup,
and it will prompt you for the new (correct) database paramters.

mythtv-users mailing list
mythtv-users at mythtv.org

More information about the mythtv-users mailing list