I'm having some trouble when moving a SQL database from an old mysql4.0 db to a newer mysql5 db. We're moving the db by copying the datafiles from the /var/db directories.
Problem is, the characters get messed up so special characters like Æ Ø and Å get rendered as
ø, å and æ
We've tried changing the charset from utf-8 to latin-1 and vice versa in phpMyAdmin.
Using iconv on a SQL file seems to work, but it can't process the character Å (apparently) and returns cannot convert after it's processed some of the file.
I was thinking about just doing a sed and replacing ø, å and æ manually, but what if there's other special characters? It doesn't seem like a good solution.
So I'm wondering what you guys have been doing when migrating to a newer mysql version, and also solving some other problems like replacing TYPE= with ENGINE=. I surely can't be the only one in the world who has been having problems doing this.
