Skip to content

Instantly share code, notes, and snippets.

@amurrell

amurrell/mysqldump create database max allowed packet

Created January 3, 2017 21:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amurrell/c03a919be11ca2db7f3ab11c750fe5a5 to your computer and use it in GitHub Desktop.
Save amurrell/c03a919be11ca2db7f3ab11c750fe5a5 to your computer and use it in GitHub Desktop.
Download ZIP
mysqldump with create database and max allowed packet switches
Raw
mysqldump create database max allowed packet
mysqldump -u user -ppassword database_name --max-allowed-packet=500M -B --add-drop-database > dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment