MariaDB Backup

Commandes de base

Informations

Backing Up a Single Database

mysqldump -u root -p database_name > database_name.sql

Backing up all databases

mysqldump -u root -p --all-databases > all-databases.sql

Append the date to te filename

mysqldump -u root -p database_name > database_name_date +"%Y-%B-%d_%R".sql

Docker backup configuration

Source the mariadb password using an ".env" file.

source .env && docker-compose exec mariadb mysqldump -uroot -p${MARIADB_ROOT_PASSWORD} --all-databases > mariadb-dump-$(date +%F_%H-%M-%S).sql

Ressources

https://www.linuxbabe.com/mariadb/how-to-back-up-mariadb-databases-from-the-command-line https://techoverflow.net/2020/12/01/how-to-backup-data-from-docker-compose-mariadb-container-using-mysqldump/