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

[Hika van den Hoven]

Hoi Mark,

Thursday, September 28, 2017, 10:54:55 PM, you 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
>    

Yes, that should work, if the ian user has r/w access there, which
shouldn't as it is inside the mythtv home-directory.


Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens