X-Git-Url: https://git.hcoop.net/hcoop/scripts.git/blobdiff_plain/3c4375e5bf35bcd0d5b21c37c060ec8f3b1e19f0..81f09f28fa981ccd403aef28babac3f7f95dc651:/hcoop-all-db-backup diff --git a/hcoop-all-db-backup b/hcoop-all-db-backup index 1a1697f..e4367e5 100755 --- a/hcoop-all-db-backup +++ b/hcoop-all-db-backup @@ -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