Help me troubleshoot database error

This support ticket is created 6 years, 6 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Tagged: Import and export

This topic contains 1 reply, has 1 voice.

Last updated by diyanK 6 years, 6 months ago.

Author

Posts

June 1, 2018 at 8:36 pm #907617

diyanK

Hi, I am trying to duplicate my website using Duplicator but It fails.

Here is the error I got while trying to import the database via phpMyAdmin:

-- Table structure for table `wp_toolset_post_guid_id`
--

CREATE TABLE IF NOT EXISTS `wp_toolset_post_guid_id` (
  `guid` varchar(190) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `post_id` bigint(20) NOT NULL,
  UNIQUE KEY `post_id` (`post_id`),
  KEY `guid` (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
MySQL said: Documentation

#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

Do you have any ideas what is causing this ?

June 1, 2018 at 8:43 pm #907625

diyanK

NVM looks like mySQL version issue.