I've built a wordpress site through a WAMP local host server and have exported it onto a single SQL file. I've installed wordpress onto my third party server but when I try to import this file onto the database I get an error.
-- Table structure for table
meta_idbigint( 20 ) UNSIGNED NOT NULL , .
comment_idbigint( 20 ) UNSIGNED NOT NULL DEFAULT '0',
meta_keyvarchar( 255 ) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ,
meta_valuelongtext COLLATE utf8mb4_unicode_520_ci ) ENGINE = MYISAM DEFAULT CHARSET = utf8mb4 COLLATE = >utf8mb4_unicode_520_ci;
MySQL said: Documentation 1273 - Unknown collation: 'utf8mb4_unicode_520_ci'
I'm not experienced enough to know what this means, could someone please explain it to me and hopefully suggest how I could fix it? Thankyou.
ps. I won't be able to reply for an hour or so.