Skip to content

Instantly share code, notes, and snippets.

@chestozo

chestozo/dump.sh

Last active October 21, 2015 10:36
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 chestozo/c0f266b272e50a2a581b to your computer and use it in GitHub Desktop.
Save chestozo/c0f266b272e50a2a581b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dump.sh
mysqldump \
--host=your-mysql-server.url \
--port=3306 \
--protocol=tcp \
--default-character-set=latin1 \
--skip-triggers "this-was-generated-by-mysqlworkbench-not-sure-you-need-this" \
--user=mister_user \
--password=IT_IS_NOT_SECURE_TO_USE_PASSWORDS_LIKE_THIS > backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment