1) to be able to update the pi, I have set up scripts that check
git-lab API once a day and download the repo when there is a new
version. is this common, is it acceptable?
Yes, also you can follow the procedure below. It's easy to create a scheduled script thanks to the "cron".
1. Create a file for the script:
sudo touch /home/update-script
The official documentation gives step by step instructions for backup.
Incremental backup allows you to just store the changes:
You can use cron to schedule the task to run nightly.
First thing to check is that your MySQL (or more likely MariaDB) server is listening on the INADDR_ANY (0.0.0.0) address. That needs a change to bind-address 0.0.0.0 in your config file.
Then use sudo netstat -tlnpu | grep mysql to check that the mysqld task is running and listening OK.
Next create a remote user as per the instructions at MySQL adding user ...
You need to install the Mariadb packages and the mysql compatibility package in your sysroot.
apt install mariadb-client mariadb-common mysql-common
libmariadb-dev-compat package will create all the links necessary for compatibility between mariadb and mysql.
Then, when you call to qt configure script you must ...
You should use a systemd unit file to start the python script on boot up and run it as service. Just create a new service with:
rpi ~$ sudo systemctl --force --full edit monitor-db.service
In the empty editor insert these statements, save them and quit the editor:
Description=Monitor Database changes