[mythtv-users] Moving my MythDB

[James]

> On 11 May 2022, at 1:18 pm, Stephen Worthington <stephen_agent at jsw.gen.nz> wrote:
> 
> On Tue, 10 May 2022 23:01:04 -0600, you wrote:
> 
>> 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. :)
> 
> It is not really a problem as you can not just put the database
> somewhere under /home and automatically back it up along with all the
> normal data there.  The databases need to be backed up properly - just
> making a copy of the files does not work.

Use mythconverg_backup.pl Then you can put the backup where you like.

James

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220511/65653020/attachment.htm>