From 4a8f83273dc26316cae81ff716502c4e817d4630 Mon Sep 17 00:00:00 2001
From: Someone <someone@somenet.org>
Date: Sun, 8 Dec 2024 16:50:58 +0100
Subject: [PATCH] roles/base/backup/files

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

diff --git a/roles/base/backup/files/default/backup.conf.managed b/roles/base/backup/files/default/backup.conf.managed
index 469af5f..9d1d1fe 100644
--- a/roles/base/backup/files/default/backup.conf.managed
+++ b/roles/base/backup/files/default/backup.conf.managed
@@ -15,6 +15,12 @@
 #done
 
 
+# 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"
+#done
+
+
 # local backup.
 #backup "/bkp/storage-local/$(hostname -s)/etc.enc"  "$(hostname -f)" "/etc"  "-d13 -w7 -m24" "passphrase"
 backup "/bkp/storage-local/$(hostname -s)/etc"      "$(hostname -f)" "/etc"  "-d13 -w7 -m24"
-- 
2.43.0