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
We've tried changing the charset from utf-8 to latin-1 and vice versa in phpMyAdmin.
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
Ã¦ 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.