[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mythtv-users
Subject:    Re: [mythtv-users] Moving my MythDB
From:       Jerome Yuzyk <jerome () supernet ! ab ! ca>
Date:       2022-05-11 5:01:04
Message-ID: 4123509.iGErgHkdLf () desk2
[Download RAW message or body]

On Tuesday, May 10, 2022 10:18:16 P.M. MDT Stephen Worthington wrote:
> On Tue, 10 May 2022 21:04:27 -0600, you wrote:
> >Does anyone store their Myth DB somewhere other than where Myth puts it?
> >
> >How would I do that?
> 
> The location of the mythconverg database is determined by MySQL or
> MariaDB, not MythTV.  As far as I know, neither has an option to store
> the databases anywhere other than one location - if you want to move
> the files somewhere else, you have to move the entire set of
> databases, not just the mythconverg database.  The location for Ubuntu
> is /var/lib/mysql.  This location is set by the "datadir" option in
> the config files under /etc/mysql, and there are various pages on the
> web that can tell you how to move the entire directory.  You may need
> to also change apparmor settings if you move it.
> 
> It is possible to store the database on a completely different machine
> - MythTV is happy to use a remote database server.
> 
> So why do you want to move the database?

I'm doing some "infrastructure" janitorial work on all my machines and noticed 
that my "pretty-important" database is buried in /var/lib/mysql and that's 
bugging the program/data separation that I usually go for. I haven't cared for 
15+ years, but now that I do, I do. :)

-- 
A little of Jerome's MythTV World: http://mythtv.HeIsJerome.com


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
[prev in list] [next in list] [prev in thread] [next in thread]