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

[Hika van den Hoven]

Hoi Ian,

Thursday, September 28, 2017, 10:11:41 PM, you wrote:

> On Thu, Sep 28, 2017 at 4:00 PM, Hika van den Hoven <hikavdh at gmail.com> wrote:
>>
>> Hoi Ian,
>>
>> Thursday, September 28, 2017, 9:32:37 PM, you 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!
>>
>> You first need to create the database and the rights before you can
>> restore.


> Not sure if I'm following. The mythtv installation has already
> created a mythconverg database which I can login to. I just need to
> restore my .27 database so that it will change the schema upon
> running. I thought   --drop_database --create_database took care of
> that. I didn't see any other step about rights on
> https://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore.
> Just thought my issue was looking for config/xml in the wrong place,
> since it is in the mythtv user locations but looking in the root user's.

Is /home/ian the root users home directory? Because then it is
completely logical. You are using sudo, so you are running as root. So
try without sudo.

> Thanks.




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