Transferring WordPress website to a New Host: SQL Import Errors

[Alan Loh]

I've been trying to transfer database files for my website that I am transferring and I am receiving the error message:

SQL Query:

-- ------------------------------------------------------------ Table structure for table `wp_icl_mo_files_domains`--CREATE TABLE `wp_icl_mo_files_domains` ( `id` int(11) NOT NULL, `file_path` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL, `file_path_md5` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL, `domain` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL, `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'not_imported', `num_of_strings` int(11) NOT NULL DEFAULT '0', `last_modified` int(11) NOT NULL, `component_type` enum('plugin','theme','other') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'other', `component_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

and

MySQL said: Documentation

#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

I am new to SQL, any assistance would be greatly appreciated.