title: Unknown collation 1273 error MySQL
body: <p>I am migrating a wordpress site but when I try to import the database I get the following error: </p>
  
  <blockquote>
    <p>1273 - Unknown collation: 'utf8mb4_unicode_520_ci'</p>
  </blockquote>
  
  <p>I think that it is caused because of the different version of MySQL, is that correct? How to fix the code below? This is how every table is created.</p>
  
  <pre><code>CREATE TABLE `wp_commentmeta` (
    `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
    `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
    `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
    PRIMARY KEY (`meta_id`),
    KEY `comment_id` (`comment_id`),
    KEY `meta_key` (`meta_key`(191))
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  </code></pre>