Part of: http://marcelog.github.io/articles/simple_daily_mysql_backup_to_s3.html

backup.sh

#!/bin/bash
cd /tmp
file=$(date +%a).sql
mysqldump \
  --host ${MYSQL_HOST} \
  --port ${MYSQL_PORT} \
  -u ${MYSQL_USER} \
  --password="${MYSQL_PASS}" \
  ${MYSQL_DB} > ${file}
if [ "${?}" -eq 0 ]; then
  gzip ${file}
  aws s3 cp ${file}.gz s3://${S3_BUCKET}
  rm ${file}.gz
else
  echo "Error backing up mysql"
  exit 255
fi

i face error, when i run this script. i keep port 3306

1. --password=${password123}: bad substitution
   Error backing up mysql
2. "Unknown MySQL server host '--port' (2)" when trying to connect
   Error backing up mysql

our method is down.
mysqldump
--host ${localhost}
--port ${3306}
-u ${user123}
--password="${password123}"
${database123} > ${file}