#!/bin/sh
FILE=mysql-$db.$DATE.sql.gz
ssh $SUSER@$SHOST "mysqldump -q -u $MUSER -h $MHOST -p$MPASS $db --no-create-db | gzip -9 > $FILE" 2> $ERROR

ssh $SUSER@$SHOST 'mysqldump -q -u $MUSER -h $MHOST -p'''$MPASS''' $db --no-create-db | gzip -9 > $FILE' 2> $ERROR

DB_HOST=000.000.000.000
DB_DATABASE=dbdame
DB_USER=db user
DB_PASS="xgT{uic[Is?uJ+"

Source dbserver.conf
MUSER=$DB_USER
MPASS=$DB_PASS
MHOST=$DB_HOST
DBS=$DB_DATABASE

MPASS=$(printf "%qn" "$DB_PASS")

ssh "$SUSER@$SHOST" "mysqldump -q -u "$MUSER" -h "$MHOST" -p"$MPASS" "$db" --no-create-db | gzip -9 > "$FILE"" 2> "$ERROR"

ssh "$SUSER@$SHOST" "mysqldump -q -u '$MUSER' -h '$MHOST' -p'$MPASS' '$db' --no-create-db | gzip -9 > '$FILE'" 2> "$ERROR"

ssh "$SUSER@$SHOST" "mysqldump -q -u '$MUSER' -h '$MHOST' -p'$MPASS' '$db' --no-create-db | gzip -9 > '$FILE' 2> '$ERROR'"