[wp-trac] [WordPress Trac] #39411: Import Error: sql database utf8mb4 versus utf8

[WordPress Trac]

#39411: Import Error: sql database utf8mb4 versus utf8
--------------------------+-----------------------------
 Reporter:  vtorres7332   |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  4.7
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 I am having an issue importing a wordpress database from my hosting
 service to Go Daddy and it seems to be because of the formatting of the
 new word press my SQL using utf8mb4 versus utf8.

 This is the error that I am getting when I try to import it to Godaddy:

 SQL query:

 --
 -- Database: `swsproje_prjctdb11`
 --
 -- --------------------------------------------------------
 --
 -- Table structure for table `wp_commentmeta`
 --
 CREATE TABLE IF NOT EXISTS  `wp_commentmeta` (

  `meta_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `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,
 PRIMARY KEY (  `meta_id` ) ,
 KEY  `comment_id` (  `comment_id` ) ,
 KEY  `meta_key` (  `meta_key` ( 191 ) )
 ) ENGINE = MYISAM DEFAULT CHARSET = utf8mb4 COLLATE =
 utf8mb4_unicode_520_ci AUTO_INCREMENT =1;

 MySQL said: Documentation

 #1273 - Unknown collation: 'utf8mb4_unicode_520_ci'


 Could you please tell me how to correct this problem, I really need to
 move over this website.

 Thank you in advance for your help.

 Victor Torres

--
Ticket URL: <https://core.trac.wordpress.org/ticket/39411>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform