[TYPO3] Upgrading mysql 4.0 to mysql4.1 -> utf-8 mismatch

[Jan Slusarczyk]

> If I take a mysqldump and import this in mysql 4.1 all the utf-encoding
> is not accepted/not right.
> How do I the upgrade right? How can I automate this?
> (I'm using some self coded tools to distribute domains automated).

I was using the following script to do the same:

mysqldump --host=192.168.X.X --user=user --password=pass 
--default_character-set=latin1 --skip-set-charset db_name > db_name.sql

chgrep latin1 utf8 db_name.sql

mysql  --user=user --password=pass --execute="DROP DATABASE db_name; 
CREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_pl;"

mysql  --user=user --password=pass --default-character-set=utf8 db_name 
< db_name.sql

Watch for a proper collation in line 3 - yours will be different...

Jan