Skip to main content

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.
Example

image-1704804469717.png