title: mysqldump and restore with special characters. øæåØÆÅ
body: <p>Locally I do this to dump and move a database, upgrading  silverstripe 2.3 to 2.4:</p>
  <pre><code>mysqldump --opt  --default-character-set=latin1 --skip-set-charset --user=$root -p$password $oldDatabase -r db.sql  
  
  iconv -f LATIN1 -t UTF8 db.sql &gt; db_utf.sql 
  
  
  CREATE DATABASE $newDatabase CHARACTER SET utf8 COLLATE utf8_swedish_ci; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON $newDatabase . * TO '$newUser'@'localhost';  FLUSH PRIVILEGES;
  SET NAMES utf8; SOURCE db_utf.sql;
  </code></pre>
  <p>And it works, but on the server Ubuntu 8.04, with mysql Ver 14.12 Distrib 5.0.51a.
  I get crazy <code>√∏</code> characters instead of <code>øæåØÆå</code>.</p>
  <p>Anyone know where I've gone wrong?</p>