Skip to content

Instantly share code, notes, and snippets.

@dsmeringe

dsmeringe/mysqldump_extended.txt

Created February 15, 2013 15:16
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 dsmeringe/4960983 to your computer and use it in GitHub Desktop.
Save dsmeringe/4960983 to your computer and use it in GitHub Desktop.
Download ZIP
Better mysql backup command. Dump list of databases with their routines (like stored procedures) (routines are normally left out) using compressed communication and adding a drop database statement in the beginning.
Raw
mysqldump_extended.txt
mysqldump -C --routines --add-drop-database -uUSERNAME -p --databases NAMES-OF-DATABASE-1 NAME-OF-DATABASE-2..
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment