#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

  • Hello,

    I am in a big mess. I was trying to transfer one of my websites done in WAMP Local server in my computer
    to one of my domain names. i have done it before and i have never come across this.

    I uploaded my Files. but i cant import my database to the live server. below error comes.

    ————————————————–
    SQL query:

    —
    — Database: studio3000_db
    —

    — ——————————————————–

    —
    — Table structure for table wp_commentmeta
    —

    CREATE TABLE wp_commentmeta (
    meta_id bigint(20) UNSIGNED NOT NULL,
    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
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    MySQL said: Documentation

    #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

    ——————————————————————

    Can anyone assist me to solve this please. I peak through some online forums its too complicated.
    Anyway according to them this is a Mysql version error.

    Did exporting the database with compatibility to Version4. but the site is not scrolling.

    What can we do???

Viewing 2 replies - 31 through 32 (of 32 total)

  • Hi Guys

    Have shifted my Website http:filmiadda.com to HostGator.in.
    have transferred all files to the same and upon importing the database i am getting error as listed below;
    ——————————————————————–
    Error
    SQL query:

    — ——————————————————–
    —
    — Table structure for table wpjz_ft_http_requests
    —
    CREATE TABLE IF NOT EXISTS wpjz_ft_http_requests (

    name VARCHAR( 191 ) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ”,
    request_uri TEXT COLLATE utf8mb4_unicode_520_ci,
    type VARCHAR( 20 ) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ,
    charset VARCHAR( 20 ) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL ,
    cache MEDIUMBLOB,
    modified_time DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    expiration_time DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    PRIMARY KEY ( name ) ,
    UNIQUE KEY name ( name )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci;

    MySQL said: Documentation

    #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

    ————————————————————–

    Pls guide. Thanks in Advance

    Thanks alfatihg80 you are a legend!!!!

Viewing 2 replies - 31 through 32 (of 32 total)
  • The topic ‘#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’’ is closed to new replies.