X-Git-Url: https://git.hcoop.net/hcoop/scripts.git/blobdiff_plain/bf301371e226b795b2533bffa3d5a38a006c035b..81f09f28fa981ccd403aef28babac3f7f95dc651:/hcoop-all-db-backup

diff --git a/hcoop-all-db-backup b/hcoop-all-db-backup
index 9db1b1d..e4367e5 100755
--- a/hcoop-all-db-backup
+++ b/hcoop-all-db-backup
@@ -6,16 +6,16 @@
 #
 
 BACKUP_ROOT=/var/backups/databases
-BACKUP_DAYS=7
+BACKUP_DAYS=2
 
 if ! test -d "$BACKUP_ROOT"; then
 	echo "Backup root directory '$BACKUP_ROOT' inaccessible."
 	exit 1
 fi
 
-MYSQL_DBS=`sudo -H mysqlshow | tail -n +4 | head -n -1 | cut -d' ' -f 2 | xargs`
+MYSQL_DBS=`sudo -H mysqlshow --defaults-file=/root/.my.fritz.cnf | tail -n +4 | head -n -1 | cut -d' ' -f 2 | xargs`
 echo "Mysql Databases are: $MYSQL_DBS"
-PGSQL_DBS=`sudo -u postgres psql template1 -c '\l' | tail -n +4 | head -n -2 | cut -d' ' -f 2 | xargs`
+PGSQL_DBS=`sudo -u postgres psql -h postgres template1 -c '\l' | tail -n +4 | head -n -2 | cut -d' ' -f 2 | xargs`
 echo "Postgres Databases are: $PGSQL_DBS"
 
 # Delete oldest
@@ -41,11 +41,11 @@ mkdir --mode=770 "$BACKUP_ROOT/mysql" "$BACKUP_ROOT/postgres"
 
 # Perform MYSQL backup
 for db in $MYSQL_DBS; do 
-	sudo -H mysqldump "$db" | gzip - > "$BACKUP_ROOT/mysql/$db.gz"
+	sudo -H mysqldump --defaults-file=/root/.my.fritz.cnf "$db" | gzip - > "$BACKUP_ROOT/mysql/$db.gz"
 done
 
 # Perform PGSQL backup
 for db in $PGSQL_DBS; do 
-	sudo -H -u postgres pg_dump "$db" | gzip - > "$BACKUP_ROOT/postgres/$db.gz"
+	sudo -H -u postgres pg_dump -h postgres "$db" | gzip - > "$BACKUP_ROOT/postgres/$db.gz"
 done