Skip to content

Instantly share code, notes, and snippets.

@tony4d
Last active December 18, 2015 11:59
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 tony4d/5779546 to your computer and use it in GitHub Desktop.
Save tony4d/5779546 to your computer and use it in GitHub Desktop.
Simple mysqldump to sync up a dev env
mysqldump -u [user_name] -p -Qce --max-allowed-packet=1024M -B [database_name] > database_name.sql
@tony4d
Copy link
Author

tony4d commented Jul 15, 2013

Updated for complete and extended inserts, better for big loads and sql files are smaller.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment