Skip to content

Instantly share code, notes, and snippets.

@fcaldarelli

fcaldarelli/mysqldump-without-affect-server-load.sh

Created June 20, 2018 19:13
Show Gist options
  • Save fcaldarelli/60ee5abc37baa6f23222176806e27bf2 to your computer and use it in GitHub Desktop.
Save fcaldarelli/60ee5abc37baa6f23222176806e27bf2 to your computer and use it in GitHub Desktop.
Download ZIP
Mysqldump without affect server load
Raw
mysqldump-without-affect-server-load.sh
mysqldump -u USER -p --single-transaction --quick --lock-tables=false DATABASE | gzip > OUTPUT.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment