Help me troubleshoot database error

This support ticket is created 6 years, 5 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.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Tagged: Import and export

This topic contains 1 reply, has 1 voice.

Last updated by diyanK 6 years, 5 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.