Skip to content

Instantly share code, notes, and snippets.

View phene's full-sized avatar

Geoffrey Hichborn phene

  • VMware
  • Palo Alto
View GitHub Profile
production:
encoding: utf8
collation: utf8_unicode_ci
script/dbconsole <env> -p < dbdump.utf8.sql
encoding: utf8
collation: utf8_unicode_ci
[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
[clients]
default-character-set=utf8
[mysql]
default-character-set=utf8
sed -e 's/CHARSET=latin1/CHARSET=utf8/g' dbdump.sql > dbdump.utf8.sql
mysqldump --default-character-set=latin1 --skip-set-charset --user=username --password=password database_name > dbdump.sql