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.
SQL query:
--
-- Database:
cosmosdesign
-- Table structure for table
wp_commentmeta
CREATE TABLE
wp_commentmeta
(meta_id
bigint( 20 ) UNSIGNED NOT NULL , .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 ) 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.