[mythtv-users] Problem installing mythtv package on Ubuntu 24.04.1 LTS

[Stephen Worthington]

On Sat, 23 Nov 2024 15:04:20 +0000, you wrote:

>On 11/23/24 14:44, Stephen Worthington wrote:
>>> [ SNIP ]
>>>
>>> I read somewhere that the mythconverg DB must exist but be empty for
>>> this to work - is this true? Recall that I have already started the
>>> setup usinghttp://localhost:6544, will this be a problem? If so, what's
>>> the magic to clear the DB?
>>>
>>> Thanks again,
>>> Chris
>> Yes, the database must exist and be empty before a full restore.  If
>> you run mythconverg_restore.pl with the --help option, you will find
>> that it has options to drop the existing database and create a new one
>> before doing the restore.  So the restore should look something like
>> this:
>>
>> sudo systemctl stop mythtv-backend
>> sudo /usr/share/mythtv/mythconverg_restore.pl --drop_database
>> --create_database --directory=<directory where the database backup
>> file is> --file=mythconverg-1379-20241118053505.sql.gz
>>
>> Then run mythconverg_restore.pl again with the --change-hostname
>> options if necessary.
>>
>> Then start mythbackend again and it should do the database schema
>> upgrade.  Then if you use any frontend only plugins like mytharchive
>> or mythmusic, you need to run mythfrontend to get it to upgrade the
>> schema for the database tables used by those plugins.
>> _______________________________________________
>
>
>OK great, that has restored my DB perfectly and I can see my old 
>recordings via the FE.
>Not able to watch live TV yet though, not sure why - it just pauses a 
>moment and then returns to thew menu when selected.
>Visiting http://127.0.0.1:6544/dashboard/status shows
>
>    Last mythfilldatabase run started on 1/3/2022 5:51PM and ended on
>    1/3/2022 5:51PM , Successful.
>    Suggested next mythfilldatabase run .
>    There's guide data until (0 days).
>
>Is it safe to run 'mythfilldatabase' at this point?
>
>Thanks again,
>Chris

Yes, you can run mythfilldatabase now (once you have set it up
properly).  That may help with the live TV problem also, as there are
some strange problems with live TV when it does not have any EPG data
- some methods of starting live TV do not work, and others do.  But
your database should actually have some current EPG data already as it
is only six days old and most broadcasters send at least seven days of
EPG.