From 215dd05ee860834263eb4111008f92851625193d Mon Sep 17 00:00:00 2001 From: Someone Date: Sun, 7 Jun 2026 02:02:43 +0200 Subject: [PATCH] roles/base/backup/files --- roles/base/backup/files/default/backup.conf.managed | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/roles/base/backup/files/default/backup.conf.managed b/roles/base/backup/files/default/backup.conf.managed index 914f4d9..8a4f520 100644 --- a/roles/base/backup/files/default/backup.conf.managed +++ b/roles/base/backup/files/default/backup.conf.managed @@ -28,8 +28,8 @@ # mysql backup (local + borgbackup 1) -#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_cmd2 "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "mysqldump --single-transaction --quick --add-drop-table --add-drop-trigger $dbname" "-d7 -w7 -m35" "PASSPHRASE_CHANGEME" +#for dbname in `echo "select distinct TABLE_SCHEMA from information_schema.tables where TABLE_SCHEMA not in ('information_schema', 'performance_schema', 'sys');" | sudo -u mysql mysql -B --column-names=false` ; do +# backup_cmd2 "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "sudo -u mysql mysqldump --single-transaction --quick --add-drop-table --add-drop-trigger $dbname" "-d7 -w7 -m35" "PASSPHRASE_CHANGEME" #done -- 2.47.3