Currently I run MariaDB in a Windows VM
I’m migrating it to TrueNAS App - step-by-step as I replicate what I have so that I understand exactly how it is step up
I have
- imported the data (Kodi Backend) to the server
- proven access to it
- done a windows mariadb-dump of it
- mapped the dump folder into the app/docker
- done linux mariadb-dump of it into the existing dump folder
Here’s where I run into a question(s)
Do/should I create cron job inside the app to do the backup? I can’t do a cron job outside without having the cron user a member of the docker group and the docker group membership can’t be changed - the cron user would need to execute a docker exec command
Having a cron job run as root seems less than ideal?
This is before I get into the naming convention of backups (I currently use DD-MM-YYYY.sql as the format KISS 
)
(Yes I know that the data is protected on the TrueNAS but if I need to say export it to a VM for whatever reason)
I can run mariadb-dump on a windows PC and continue with this but I was hoping to get it all the TrueNAS