[mythtv-users] optimize_mythdb.pl - "unable to locate mysql.txt"

[Stef Coene]

On Saturday 01 December 2007, Jose Bernardo Silva wrote:
> Hi,
> I am running kubuntu x86_64 gutsy, with the mythbuntu svn packages.
> When I try to run optimize_mythdb.pl I always get the same error -
> "Unable to locate mysql.txt:". I have a /etc/mythtv/mysql.txt, which
> is also linked to /usr/share/mythtv, and which has the correct values
> for the database, user, and password.
> Any ideas on where else to look?

grep mysql.txt /usr/share/doc/mythtv-backend/contrib/optimize_mythdb.pl

This will show you all places where the script is looking for mysql.txt.
In my case this is:
    my @mysql = ('/usr/local/share/mythtv/mysql.txt',
                 '/usr/share/mythtv/mysql.txt',
                 '/etc/mythtv/mysql.txt',
                 '/usr/local/etc/mythtv/mysql.txt',
                 "$ENV{HOME}/.mythtv/mysql.txt",
                 'mysql.txt'


Stef