Fix database encoding issue (export Latin-1, import UTF-8)

gistfile1.md

$ mysqldump -u root -p --opt --quote-names --skip-set-charset --default-character-set=latin1 [database name] > dump.sql
$ mysql -u root -p --default-character-set=utf8 [database name] < dump.sql

Source: http://www.garethsprice.com/blog/2011/fix-mysql-latin1-utf-character-encoding/