Convert a MySQL database to UTF-8
From Joomla! Documentation
(Difference between revisions)
(New page: After searching a long time for a solution when I upgraded from MySQL 4.0 to 5.0 I found this, <source lang="bash"> mysqldump --user=username --password=password --default-character-set=l...) |
(Added Category:Database) |
||
| (One intermediate revision by one user not shown) | |||
| Line 5: | Line 5: | ||
sed -r 's/latin1/utf8/g' dump.sql > dump_utf.sql | sed -r 's/latin1/utf8/g' dump.sql > dump_utf.sql | ||
mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;" | mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;" | ||
| − | mysql --user=username --password=password --default-character-set=utf8 dbname < | + | mysql --user=username --password=password --default-character-set=utf8 dbname < dump_utf.sql |
</source> | </source> | ||
| Line 13: | Line 13: | ||
[[Category:Tips and tricks 1.0]] | [[Category:Tips and tricks 1.0]] | ||
[[Category:Tips and tricks 1.5]] | [[Category:Tips and tricks 1.5]] | ||
| + | [[Category:Database]] | ||
Latest revision as of 11:05, 7 March 2009
After searching a long time for a solution when I upgraded from MySQL 4.0 to 5.0 I found this,
mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset dbname > dump.sql sed -r 's/latin1/utf8/g' dump.sql > dump_utf.sql mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;" mysql --user=username --password=password --default-character-set=utf8 dbname < dump_utf.sql
This worked perfectly for me.
