title: how to dump latin1 encoded tables to utf8 encoded tables in MYSQL?
body: <p>I can dump the data through phpmyadmin,
  then use </p>
  
  <pre><code>$utf8 = iconv('latin1','utf-8//IGNORE',$latin1);
  </code></pre>
  
  <p>to convert it into utf8 encoding,</p>
  
  <p>but see many messy code</p>