How to solve MySQL dump import problem?

Question

MySQL

Hello toaster! The problem is as follows:
The database was created in PHPMYADMIN under WIN2012r2 IIS. Wordpress was installed there and it lives very well there. I wanted to temporarily move to a nix server (hosting) and a dump from phpmyadmin was merged in the hope of uploading it from the hoster. And then there's this crap:

SQL-запрос:

--
-- База данных: `hipster`
--
-- --------------------------------------------------------
--
-- Структура таблицы `wp_2_commentmeta`
--
CREATE TABLE IF NOT EXISTS `wp_2_commentmeta` (
`meta_id` bigint( 20 ) unsigned NOT NULL ,
`comment_id` bigint( 20 ) unsigned NOT NULL DEFAULT '0',
`meta_key` varchar( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
`meta_value` longtext COLLATE utf8mb4_unicode_ci
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Ответ MySQL: Документация
#1273 - Unknown collation: 'utf8mb4_unicode_ci'

Where to dig? Previously, from Lin to Vin, I poured bases of norms and vice versa, but here it’s some kind of zapadlo (
Help pliz!

Answer 1

If it is not possible to upgrade MySQL, then replace utf8mb4 with utf8, utf8mb4_unicode_ci with utf8_unicode_ci, i.e. delete mb4. But I highly recommend the upgrade.

Answer 2

Step 1. Enter an error in the search engine.
Step 2. See documentation link .
Step 3. Read what utf8mb4 comparison and some others have added in mysql 5.5.3.
Step 4. Check the version on the server.