Hello, I’m running MariaDB inside a container and having trouble with incomplete backups. I’ve tried using both the SPBackupRestore application and the DBeaver dump database tool, but neither produces a complete backup.
When I set up my MariaDB instance in the container, I configured it with a max_allowed_packet of 1024M. Here’s the command I used:
podman run --detach --pod mariadb_4_sp7_pod --name mariadb_4_sp7 -v /apps/data/lfc/containers/volumes/specify-mariadb:/var/lib/mysql:Z --env-file='./mysql.env' mariadb:10.11 --max-allowed-packet=1024M
When I run the following command to check the configuration, it returns a value of 1073741824:
SHOW VARIABLES LIKE 'max_allowed_packet';
1024 MB is equal to 1,073,741,824 bytes so it seems ok.
Has anyone encountered this issue with MariaDB in a container and found a solution?