From 558734b67c9f9b491c89975270ad484340bf353c Mon Sep 17 00:00:00 2001
From: mhoellein <mhoellein@freenet.de>
Date: Thu, 27 Sep 2018 06:33:11 +0200
Subject: [PATCH] backup Datenbank

---
 mysql/backup_mysql.sh | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 mysql/backup_mysql.sh

diff --git a/mysql/backup_mysql.sh b/mysql/backup_mysql.sh
new file mode 100644
index 0000000..2faa866
--- /dev/null
+++ b/mysql/backup_mysql.sh
@@ -0,0 +1,14 @@
+#!/bin/bash
+
+### ... mysql -u admin -p`cat /root/.mysqlpw` | grep  ...
+### set PW in option-File ~/.my.cnf
+
+[ -s ~/.my.cnf ] || exit 1
+[ -d /var/adm/backup/mysql ] || mkdir -p /var/adm/backup/mysql
+
+for db in $(echo "show databases;" | mysql -u admin | grep -vE '^(Database|information_schema|performance_schema)'); do
+   mysqldump -u admin --extended-insert --complete-insert --create-options --add-drop-table --add-locks --lock-tables --events --databases $db |\
+       xz > /var/adm/backup/mysql/$db.$(date +%Y%m%d%H%M%S).sql.xz
+done
+
+find /var/adm/backup/mysql/ -maxdepth 1 -name \*.sql.xz      -mtime +7 -print0  | xargs -0 -r rm -f
-- 
2.43.0