Skip to content

Instantly share code, notes, and snippets.

@maxistar

maxistar/gist:0cec94c4e3b936c6296f

Created November 26, 2014 05: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 maxistar/0cec94c4e3b936c6296f to your computer and use it in GitHub Desktop.
Save maxistar/0cec94c4e3b936c6296f to your computer and use it in GitHub Desktop.
Download ZIP
Restoring broken mysql encoding
Raw
gistfile1.txt
mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names \
--skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql
mysql -h DB_HOST -u DB_USER -p DB_PASSWORD \
--default-character-set=utf8 DB_NAME < DB_NAME-dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment