Skip to content

Instantly share code, notes, and snippets.

@ssskip
Last active October 25, 2017 16:25
Show Gist options
  • Save ssskip/d121b04e76c013e82933cb69faa38659 to your computer and use it in GitHub Desktop.
Save ssskip/d121b04e76c013e82933cb69faa38659 to your computer and use it in GitHub Desktop.
mysql dump on slave
mysqldump -u xxx -p -Qce -R --apply-slave-statements --single-transaction —tz-utc --flush-privileges —master-data=2 --max-allowed-packet=900M --databases xxx|pv|gzip > dump.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment