Mysql character set and collations - UTF8mb4 520
<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>