Problem importing SQL database

  • Riavon

    (@riavon)


    8 years ago

    I’m running into a problem migrating a site that uses this plugin. The import gets hung at this error:
    -- Table structure for tablewp_cwa`
    —

    CREATE TABLE IF NOT EXISTS wp_cwa (
    id mediumint(9) NOT NULL AUTO_INCREMENT,
    cwa_name tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,
    cwa_description text COLLATE utf8mb4_unicode_520_ci NOT NULL,
    cwa_id varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    cwa_widget_class text COLLATE utf8mb4_unicode_520_ci,
    cwa_widget_wrapper text COLLATE utf8mb4_unicode_520_ci,
    cwa_widget_header_class text COLLATE utf8mb4_unicode_520_ci,
    cwa_widget_header_wrapper text COLLATE utf8mb4_unicode_520_ci,
    cwa_type varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
    last_updated date NOT NULL,
    UNIQUE KEY id (id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=6 ;

    MySQL said: Documentation
    #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ `

  • The topic ‘Problem importing SQL database’ is closed to new replies.

Tags