Dump by cron

[2andgi]

Can someone give a good advice. This configuration works, but is everything correct overall?

version: "3.6"
services:
  mariadbackup:
    container_name: "mariadbackup"
    environment:
      - "DB_SERVER=192.168.1.101"
      - "DB_PORT=3306"
      - "DB_USER=root"
      - "DB_PASS="
      - "DB_DUMP_BY_SCHEMA=true"
      - "MYSQLDUMP_OPTS=--default-character-set=utf8mb4"
      - "DB_DUMP_SAFECHARS=true"
      - "DB_DUMP_TARGET=/db"
      - "DB_DUMP_CRON=0 2 * * *"
      - "TZ=Europe/Kyiv"
      - "TRACE_STDERR=true"
    hostname: "NAS-LEM11"
    image: "databack/mysql-backup:latest"
    user: "0"
    command: dump cron
    network_mode: "bridge"
    restart: "unless-stopped"
    volumes:
      - "/srv/dev-disk-by-uuid-e560a162/MariaDBbackup:/db"

[deitch]

In principle, yes. Some of the environment variables have changed, and some are not really used. For example, TZ no longer is used, nor is MYSQLDUMP_OPTS, since it is not using the mysqldump command anymore.

You can see a full list of options in the table in configuration.md