Support » Localhost Installs » #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

  • Achintha

    (@achintha)



    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 15 replies - 1 through 15 (of 34 total)
Viewing 15 replies - 1 through 15 (of 34 total)
  • The topic ‘#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’’ is closed to new replies.