Skip to content

Instantly share code, notes, and snippets.

Geoffrey Hichborn phene

  • VMware - Socialcast
  • Palo Alto
View GitHub Profile
View database.yml
production:
encoding: utf8
collation: utf8_unicode_ci
View gist:1051897
script/dbconsole <env> -p < dbdump.utf8.sql
View database.yml
encoding: utf8
collation: utf8_unicode_ci
View my.cnf
[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
[clients]
default-character-set=utf8
[mysql]
default-character-set=utf8
View gist:1051889
sed -e 's/CHARSET=latin1/CHARSET=utf8/g' dbdump.sql > dbdump.utf8.sql
View gist:1051886
mysqldump --default-character-set=latin1 --skip-set-charset --user=username --password=password database_name > dbdump.sql
You can’t perform that action at this time.