Skip to content

Instantly share code, notes, and snippets.

View phene's full-sized avatar

Geoffrey Hichborn phene

30 followers · 21 following
  • VMware
  • Palo Alto
View GitHub Profile
@phene
phene / gist:1051886
Created June 28, 2011 18:52
mysqldump --default-character-set=latin1 --skip-set-charset --user=username --password=password database_name > dbdump.sql
@phene
phene / gist:1051889
Created June 28, 2011 18:54
sed -e 's/CHARSET=latin1/CHARSET=utf8/g' dbdump.sql > dbdump.utf8.sql
@phene
phene / my.cnf
Created June 28, 2011 18:55
[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
[clients]
default-character-set=utf8
[mysql]
default-character-set=utf8
@phene
phene / database.yml
Created June 28, 2011 18:55
encoding: utf8
collation: utf8_unicode_ci
@phene
phene / gist:1051897
Created June 28, 2011 18:56
script/dbconsole <env> -p < dbdump.utf8.sql
@phene
phene / database.yml
Created June 30, 2011 17:02
production:
encoding: utf8
collation: utf8_unicode_ci