From 556ec4a888023cb771be892c67278170583da5f4 Mon Sep 17 00:00:00 2001 From: Michael Scherer Date: Mon, 23 Mar 2015 14:24:37 +0100 Subject: Deploy mariadb backups --- roles/mariadb/files/dump_mariadb.sh | 5 +++++ roles/mariadb/tasks/main.yml | 4 ++++ 2 files changed, 9 insertions(+) create mode 100644 roles/mariadb/files/dump_mariadb.sh diff --git a/roles/mariadb/files/dump_mariadb.sh b/roles/mariadb/files/dump_mariadb.sh new file mode 100644 index 0000000..94ff66b --- /dev/null +++ b/roles/mariadb/files/dump_mariadb.sh @@ -0,0 +1,5 @@ +#!/bin/bash +DIR=/var/backups/mariadb/ +[ -d $DIR ] || mkdir -p $DIR + +mysqldump --all-databases > $DIR/dump.sql diff --git a/roles/mariadb/tasks/main.yml b/roles/mariadb/tasks/main.yml index 10783bb..d311b70 100644 --- a/roles/mariadb/tasks/main.yml +++ b/roles/mariadb/tasks/main.yml @@ -7,3 +7,7 @@ notify: restart mariadb - service: name=mariadb enabled=yes state=started + +- copy: mode=0755 src=dump_mariadb.sh dest=/usr/local/bin/dump_mariadb.sh + +- cron: minute=15 hour=4 name="backup mariadb" job=/usr/local/bin/dump_mariadb.sh -- cgit