title: Mysql character set and collations - UTF8mb4 520
body: <p>Problem: mysqldump will not import due to missing collation</p>
  
  <blockquote>
    <h1>1273 - Unknown collation: 'utf8mb4_unicode_520_ci'</h1>
  </blockquote>
  
  <p>The Mysql server is (from phpMyAdmin): </p>
  
  <pre><code>Server version: 5.5.40 - MySQL Community 
  Server charset: UTF-8 Unicode (utf8)
  Database client version: libmysql - 5.0.95
  </code></pre>
  
  <p>This is a centos 5.11 server.</p>
  
  <pre><code>mysql&gt; show variables where Variable_name like 'character\_set\_%' or Variable_n                            ame like 'collation%';
  +--------------------------+-----------------+
  | Variable_name            | Value           |
  +--------------------------+-----------------+
  | character_set_client     | utf8            |
  | character_set_connection | utf8            |
  | character_set_database   | utf8            |
  | character_set_filesystem | binary          |
  | character_set_results    | utf8            |
  | character_set_server     | utf8            |
  | character_set_system     | utf8            |
  | collation_connection     | utf8_general_ci |
  | collation_database       | utf8_general_ci |
  | collation_server         | utf8_general_ci |
  +--------------------------+-----------------+
  10 rows in set (0.00 sec)
  </code></pre>
  
  <p>I have local server (xampp) which has </p>
  
  <pre><code>&gt; Server version: 10.1.9-MariaDB - mariadb.org binary distribution
  &gt; Server charset: UTF-8 Unicode (utf8)  Database client version:
  &gt; libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id:
  &gt; 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
  </code></pre>
  
  <p>This imports fine.
  Looking at the final tables that are imported I see that the collation for all tables is utf8mb4_unicode_ci.
  The same happens (i.e. as my local which imports correctly) when I upload to a public server</p>
  
  <pre><code>Server version: 5.6.29 - MySQL Community Server (GPL)
  Database client version: libmysql - 5.1.73
  </code></pre>
  
  <p><strong>Why does my local database handle the 520 collation whereas the centos box does not?</strong></p>
  
  <p>Any pointers in the right direction are appreciated. All uploads are performed via phpMyAdmin with the specs above.
  I know I can 'update' the SQL dump and remove the '520' reference and just replace with utf8mb4_unicode_ci but if you have to do this every time it's not very economical.</p>