X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=nixops%2Fmodules%2Fdatabases%2Fmysql.nix;fp=nixops%2Fmodules%2Fdatabases%2Fmysql.nix;h=a625d48be46f44f085985f85d27ce481314c4dfd;hb=85fe2b41c2ba3a50d94a0d3f5a0910c395fda994;hp=acf47509d573be234a135c6d881727a7716b59be;hpb=4ff905632320a55e0c69500891642d98a00245e2;p=perso%2FImmae%2FConfig%2FNix.git

diff --git a/nixops/modules/databases/mysql.nix b/nixops/modules/databases/mysql.nix
index acf4750..a625d48 100644
--- a/nixops/modules/databases/mysql.nix
+++ b/nixops/modules/databases/mysql.nix
@@ -51,6 +51,21 @@ in {
       '';
     };
 
+    services.cron = {
+      enable = true;
+      systemCronJobs = let
+        mycnf = pkgs.writeText "my.cnf" ''
+          [mysqldump]
+          user = root
+          password = ${myconfig.env.databases.mysql.systemUsers.root}
+          '';
+      in [
+        ''
+          30 1,13 * * * root ${pkgs.mariadb}/bin/mysqldump --defaults-file=${mycnf} --all-databases > /var/lib/mysql/backup.sql
+        ''
+      ];
+    };
+
     security.pam.services = let
       pam_ldap = "${pkgs.pam_ldap}/lib/security/pam_ldap.so";
       pam_ldap_mysql = with myconfig.env.databases.mysql.pam;