Skip to content

Instantly share code, notes, and snippets.

@matiangul
Created March 12, 2014 20:34
Show Gist options
  • Save matiangul/9515727 to your computer and use it in GitHub Desktop.
Save matiangul/9515727 to your computer and use it in GitHub Desktop.
Mysql latin1 to utf-8 chars conversion
mysqldump -u $user -p --opt --quote-names --skip-set-charset --default-character-set=latin1 $dbname > dump.sql
mysql -u $user -p --default-character-set=utf8 $dbname < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment