[mythtv-users] Moving my MythDB

[Hika van den Hoven]

Hoi Stephen,

Wednesday, May 11, 2022, 12:05:00 PM, you wrote:

> On Wed, 11 May 2022 10:33:52 +0100, you wrote:

>>>
>>> On Wed, 11 May 2022 at 08:00, James <jam at tigger.ws> wrote:
>>>
>>Use mythconverg_backup.pl Then you can put the backup where you like.
>>>
>>
>>If backups are the issue here (although I think the OP really wants
>>separation of data from the system), then it's likely they are already
>>being made if a packaged version of MythTV is installed.  The Ubuntu PPA,
>>for example, runs a backup via /etc/cron.weekly/mythtv-database which in
>>turn runs mythconverg_backup.pl.  Where that ends up with the PPA I'm not
>>100% sure as I am personally using an old Debian 0.28 installation, but
>>it's likely there will be mythconverg.sql.* files in /var/backup which can
>>be safely backed up.  If they are stored elsewhere, hopefully somebody else
>>can confirm the location.  If more frequent backups are wanted, you could
>>run the backup script in /etc/cron.daily instead.
>>
>>The other option (moving the data to separate it) could be done by shutting
>>down mythtv-backend and mysql services, moving the mysql directory from
>>from /var/lib to say, /home and then either reconfiguring mysql or using a
>>symbolic link, but as mentioned previously, AppArmor config might need
>>adjusting in that case depending on your distribution.
>>
>>Cheers, Ian

> The default location for backups on a Ubuntu system is
> /var/lib/mythtv/db_backups.  You can set a storagegroup to change the
> backup location, or alter it on the mythconverg_backup.pl command
> line.
> _______________________________________________

If the issue is separation from the system, you can consider using
multiple volumes. I myself use lvm volumes for home, usr, var, opt and
the different tmp directories. And more if needed, like the
recordings. I can resize any of the volumes at need and even add a new
disk to the volume group or migrate the group to a bigger disk. All
without disturbing the system

You can for instance put /var/lib/mysql on its own volume. Thus it
cannot flood the system. Also you can mount volumes that do not need
writing as read-only.

You even can put the root on lvm, but that is a little bit more
tricky.

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