# 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