mysql utf8 convert

here a easy way to convert your mysql database to utf8:

mysqldump -u hybris -p --default-character-set=latin1 --skip-set-charset hybris > hybrisdump.sql
iconv -f ISO8859-1 -t UTF-8 hybrisdump.sql > dump_utf8.sql
sed -r 's/latin1/utf8/g' dump_utf8.sql > hybrisdump_utf.sql

mysql -u hybris -p --execute="DROP DATABASE hybris; CREATE DATABASE hybris CHARACTER SET utf8 COLLATE utf8_general_ci;"
mysql -u hybris -p --default-character-set=utf8 hybris < hybrisdump_utf.sql