[mythtv-users] Proper way/user to run mythconverg_restore.pl when restoring old database on clean install

[Mark Perkins]

On 29 September 2017 6:25:17 am Mark Perkins <perkins1724 at hotmail.com> wrote:

> On 29 September 2017 5:03:03 am Ian Evans <dheianevans at gmail.com> wrote:
>
>> Doing the clean install method after upgrading my system to 16.04.
>>
>> I ran the following command line to install the old database:
>>
>> sudo -u mythtv /usr/share/mythtv/mythconverg_restore.pl --verbose
>> --drop_database --create_database  --directory /home/mythtv --filename
>> mythconverg-1317-20170928112702.sql.gz
>>
>> It fails with an unable to connect to database and this environment:
>>
>> Configuring environment:
>>   -    username: mythtv
>>   -        HOME: /home/ian
>>   - MYTHCONFDIR: /home/ian/.mythtv
>>
>> Parsing configuration files:
>>   - checking: /home/ian/.mythtv/config.xml
>>   - checking: /usr/local/share/mythtv/mysql.txt
>>   - checking: /usr/share/mythtv/mysql.txt
>>   - checking: /usr/local/etc/mythtv/mysql.txt
>>   - checking: /etc/mythtv/mysql.txt
>>   - checking: /home/ian/.mythtv/mysql.txt
>>   - checking: mysql.txt
>>   - checking: /home/ian/.mythtv/mysql.txt
>>   - checking: /home/ian/.mythtv/backuprc
>>
>> Doing a 'locate config.xml' it's only at these locations:
>>
>> /etc/mythtv/config.xml
>> /home/mythtv/.mythtv/config.xml
>> /usr/share/doc/mythtv-backend/contrib/config_files/config.xml
>> /usr/share/mythtv/config.xml
>>
>> How do I get the command line to ignore /home/ian and /home/ian/.mythtv?
>>
>> Thanks!
>>
>>
>>
>
> Set MYTHCONFDIR before you run your command line to the config file you want.
>
> export MYTHCONFDIR=xxxxxxxxxx
> echo $MYTHCONFDIR
>
>
>

Maybe just to add for completeness (IIUC) you can pass mythconverg_restore.pl a db user on the command line however it will ignore any provided db password passed on the command line. It instead will only pull the password from the config.xml file.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170928/78c26d42/attachment.html>