I tried transferring the WordPress on localhost to the hosting server I purchased. I uploaded all the files, etc. I imported the database I exported from localhost into the database I created on the hosting, but encountered the following error:
SQL query:
-- -- Database: `wordpressdb` -- -- -------------------------------------------------------- -- -- 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 output: #1273 - Unknown collation: 'utf8mb4_unicode_520_ci'
SQL query:
-- -- Database: `wordpressdb` -- -- -------------------------------------------------------- -- -- 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 output: #1273 - Unknown collation: 'utf8mb4_unicode_520_ci'