Skip to content

Instantly share code, notes, and snippets.

@lavoiesl
Last active December 20, 2020 15:46
Show Gist options
  • Save lavoiesl/11022667 to your computer and use it in GitHub Desktop.
Save lavoiesl/11022667 to your computer and use it in GitHub Desktop.
mysqldump
#!/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment