Skip to content

Instantly share code, notes, and snippets.

@joram77

joram77/mysql-dump-large-production-no-performance-penalty

Created October 5, 2023 12:38
Show Gist options
  • Save joram77/a277bfd97a1e5c8665816c05604bf369 to your computer and use it in GitHub Desktop.
Save joram77/a277bfd97a1e5c8665816c05604bf369 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-dump-large-production-no-performance-penalty
mysqldump -u USER -p --single-transaction --quick --lock-tables=false DATABASE | gzip > OUTPUT.gz
The mysqldump reference at dev.mysql.com even says...
To dump large tables, you should combine the --single-transaction option with --quick.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment