Add database backup

1 files changed, 4 insertions, 1 deletions

diff --git a/systems/backup-2/databases/mariadb_replication.nix b/systems/backup-2/databases/mariadb_replication.nix
index f113219..c085682 100644
--- a/systems/backup-2/databases/mariadb_replication.nix
+++ b/systems/backup-2/databases/mariadb_replication.nix
@@ -163,6 +163,9 @@ in
                 --flush-privileges \
                 --all-databases > $filename
               ${pkgs.gzip}/bin/gzip $filename
+
+              mkdir -p "${cfg.base}/${name}/databases_latest_backups"
+              ln -f "$filename.gz" "${cfg.base}/${name}/databases_latest_backups/mysql.sql.gz"
             '';
           u = pkgs.callPackage ./utils.nix {};
           cleanup_script = pkgs.writeScript "cleanup_mysql_${name}" (u.exponentialDumps "sql.gz" backupDir);
@@ -194,7 +197,7 @@ in
       }
     ) cfg.hosts;
 
-    environment.systemPackages = lib.mapAttrsToList (name: hcfg:
+    environment.systemPackages = [ pkgs.mariadb ] ++ lib.mapAttrsToList (name: hcfg:
       pkgs.writeScriptBin "mysql_backup_${name}" ''
         #!${pkgs.stdenv.shell}