Skip to content

Instantly share code, notes, and snippets.

@leite

leite/mysqldump.mkd

Last active March 19, 2016 20:41
Show Gist options
  • Save leite/0de8d7cbcc50eb4862a9 to your computer and use it in GitHub Desktop.
Save leite/0de8d7cbcc50eb4862a9 to your computer and use it in GitHub Desktop.
Download ZIP
compact mysql dump
Raw
mysqldump.mkd

compact mysql dump

$> mysqldump -u root -p --hex-blob --routines --triggers --compact YOUR_DATABASE_HERE | \
  egrep -v "(^SET|^/\*\!)" | sed 's/ AUTO_INCREMENT=[0-9]*\b//' | \
  sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' > YOUR_DATABASE_HERE.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment