mysqldump

mysqldump.sh

#!/bin/sh
#
# @link https://gist.github.com/lavoiesl/11022667

mysqldump $@ \
  --set-gtid-purged=OFF \
  --skip-comments \
  --hex-blob \
  --create-options \
  --disable-keys \
  --add-drop-table \
  --add-drop-trigger \
  --comments \
  --dump-date \
  --quote-names \
  --events \
  --routines \
  --triggers \
  --extended-insert \
  --add-locks \
  --single-transaction