Use credentials in /etc/mysql/debian.cnf to export MySQL database

export-database.sh

#!/bin/bash
# Use credentials in /etc/mysql/debian.cnf to export MySQL database

database="$1"
shift
options="$@"

if [[ -z "$database" ]]; then
  echo "Usage: $0 database [options]" >&2
  exit 2
fi

sudo mysqldump \
  --defaults-file=/etc/mysql/debian.cnf \
  --add-drop-table \
  --add-locks \
  --comments \
  --create-options \
  --disable-keys \
  --dump-date \
  --extended-insert \
  --no-create-db \
  --lock-tables \
  --set-charset \
  --quick \
  --routines \
  --events \
  --triggers \
  $options \
  $database