Skip to content

Instantly share code, notes, and snippets.

@mourique

mourique/mysql dump

Created May 2, 2011 12:08
Show Gist options
  • Save mourique/951509 to your computer and use it in GitHub Desktop.
Save mourique/951509 to your computer and use it in GitHub Desktop.
Download ZIP
Some mysql oneliners
Raw
mysql dump
# getting stuff out
mysqldump --default-character-set=utf8 --max_allowed_packet=32M --opt -hHOST -uUSER -pPASSWORD DATABASE > database.sql
# getting stuff in
mysql --default-character-set=utf8 --max_allowed_packet=32M -hHOST -uUSER -pPASSWORD DATABASE < database.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment