How to make a Mariadb Backup?
You can perform Mariadb backup by executing the following command:
sudo docker exec -i MARIADB_CONTAINER_NAME mariadb-dump -u root -p soffid01 | gzip > /some/path/on/your/host/soffid01.dump.gz
This action requires the root password.
You can use:
--max-allowed-packet=512M
: sets the maximum packet size to 512MB to handle large databases.--skip-add-locks
and--skip-lock-tables
: these options are used to improve performance by skipping certain locking mechanisms.