From 5f1938d199f66124de186892602c47dd0ec84bae Mon Sep 17 00:00:00 2001
From: Someone <someone@somenet.org>
Date: Mon, 16 Dec 2024 20:26:44 +0100
Subject: [PATCH] roles/base/backup/files

---
 roles/base/backup/files/default/backup.conf.managed | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/roles/base/backup/files/default/backup.conf.managed b/roles/base/backup/files/default/backup.conf.managed
index 9d1d1fe..f32f714 100644
--- a/roles/base/backup/files/default/backup.conf.managed
+++ b/roles/base/backup/files/default/backup.conf.managed
@@ -6,6 +6,7 @@
 # 2017-2024 by someone <someone@somenet.org>
 #
 # beware of pruning logic.
+# replace "passphrase" with something useful, or delete it for no encryption.
 #
 
 # postgresql backup.
@@ -17,7 +18,7 @@
 
 # mysql backup.
 #for dbname in `echo "select distinct TABLE_SCHEMA from information_schema.tables where TABLE_SCHEMA not in ('information_schema', 'performance_schema', 'sys');" | mysql -B --column-names=false` ; do
-#    backup_cmd "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "mysqldump --add-drop-database=true $dbname" "-d13 -w7 -m24" "bulb8Who2burly"
+#    backup_cmd "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "mysqldump --single-transaction --quick --add-drop-table --add-drop-trigger $dbname" "-d13 -w7 -m24" "passphrase"
 #done
 
 
-- 
2.43.0