[mythtvnz] Database management

[Paul]

On 23/07/21 3:43 pm, Paul wrote:
> Hi All
>
> What is the current set up for database optimisation?
>
> In Mythbuntu 16.04 I selected "optimise database" in mythbuntu control 
> panel and a cron job was set up to run  optimize_mythdb.pl
>
> I'm using the forked  Mythbuntu control panel in Xubuntu 20.04 ,but it 
> has no database set up functions.
>
> Prior to creating a cron job to run optimize_mythdb.pl, I tried to run 
> optimize_mythdb.pl from the command line and I get:
>
> Can't locate MythTV.pm in @INC (you may need to install the MythTV 
> module) (@INC contains: /etc/perl 
> /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 
> /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 
> /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 
> /usr/share/perl/5.30 /usr/local/lib/site_perl 
> /usr/lib/x86_64-linux-gnu/perl-base) at 
> /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl 
> line 15.
>
> Perl 5.30 is installed on my system
>
> I found this thread: 
> https://lists.archive.carbon60.com/mythtv/users/628894?search_string=MythTV.pm;#628894 
> <https://lists.archive.carbon60.com/mythtv/users/628894?search_string=MythTV.pm;#628894> 
>
>
> Is the solution suggested advisable ,or are  there  other suggestions?
>
> Thanks
>
> Paul
>
Further searching on the web prompted me to check if libmythtv-perl was 
installed - which it wasn't.

And in spite of things I read but didn't quite understand regarding @INC 
being set at compilation , after installing libmythtv-perl ,to my 
surprise, optimize_mythdb.pl  now seems to function - at least running 
from the command  reports no errors.

Cheers

Paul

>
>