Dev/Mariadb

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password docker run -it --env-file .db.env -v /Users/tjen/dev/tjen/homeserver/tmp/firefly-iii-docker/test-db-backup:/test-db-backup -v firefly-iii-docker_firefly_iii_db:/var/lib/mysql --env MARIADB_ROOT_PASSWORD=foo --env MYSQL_RANDOM_ROOT_PASSWORD=false mariadb:lts --skip-grant-tables docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 3c93299d33b3 mariadb:lts “docker-entrypoint.s…” 7 seconds ago Up 7 seconds 3306/tcp romantic_hamilton docker exec -it romantic_hamilton /bin/bash root@3c93299d33b3:/# mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 11.4.2-MariaDB-ubu2404 mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others....

src: https://github.com/orgs/firefly-iii/discussions/7698#discussioncomment-6544051

src: https://www.mydbops.com/blog/backup-and-recovery-using%C2%A0mariabackup/ mariabackup --backup --target-dir=/test-db-backup --user=root --password=foo mariabackup: Deprecated program name. It will be removed in a future release, use ‘/usr/bin/mariadb-backup’ instead [00] 2024-07-27 13:33:25 Connecting to MariaDB server host: localhost, user: root, password: set, port: not set, socket: /run/mysqld/mysqld.sock [00] 2024-07-27 13:33:25 Using server version 11.4.2-MariaDB-ubu2404 mariabackup based on MariaDB server 11.4.2-MariaDB debian-linux-gnu (aarch64) [00] 2024-07-27 13:33:25 uses posix_fadvise(). … [00] 2024-07-27 13:33:29 …done [00] 2024-07-27 13:33:29 Redo log (from LSN 8979194 to 8979210) was copied....