{"id":8813713,"date":"2017-02-16T18:32:12","date_gmt":"2017-02-16T18:32:12","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/problem-importing-sql-database\/"},"modified":"2017-02-16T18:32:12","modified_gmt":"2017-02-16T18:32:12","slug":"problem-importing-sql-database","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/problem-importing-sql-database\/","title":{"rendered":"Problem importing SQL database"},"content":{"rendered":"<p>I&#8217;m running into a problem migrating a site that uses this plugin. The import gets hung at this error:<br \/>\n<code>-- Table structure for table<\/code>wp_cwa`<br \/>\n&#8212;<\/p>\n<p>CREATE TABLE IF NOT EXISTS <code>wp_cwa<\/code> (<br \/>\n  <code>id<\/code> mediumint(9) NOT NULL AUTO_INCREMENT,<br \/>\n  <code>cwa_name<\/code> tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,<br \/>\n  <code>cwa_description<\/code> text COLLATE utf8mb4_unicode_520_ci NOT NULL,<br \/>\n  <code>cwa_id<\/code> varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,<br \/>\n  <code>cwa_widget_class<\/code> text COLLATE utf8mb4_unicode_520_ci,<br \/>\n  <code>cwa_widget_wrapper<\/code> text COLLATE utf8mb4_unicode_520_ci,<br \/>\n  <code>cwa_widget_header_class<\/code> text COLLATE utf8mb4_unicode_520_ci,<br \/>\n  <code>cwa_widget_header_wrapper<\/code> text COLLATE utf8mb4_unicode_520_ci,<br \/>\n  <code>cwa_type<\/code> varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,<br \/>\n  <code>last_updated<\/code> date NOT NULL,<br \/>\n  UNIQUE KEY <code>id<\/code> (<code>id<\/code>)<br \/>\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=6 ;<\/p>\n<p>MySQL said: Documentation<br \/>\n#1273 &#8211; Unknown collation: &#8216;utf8mb4_unicode_520_ci&#8217; `<\/p>\n","protected":false},"template":"","class_list":["post-8813713","topic","type-topic","status-publish","hentry","topic-tag-sql-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/8813713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/8813713\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=8813713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}