phpmyadmin database import error – #1273

  • hatchbackcreative

    (@hatchbackcreative)


    9 years, 1 month ago

    I am trying to import a .sql database to another server with phpmyadmin, but am getting the following error. Can you help please? Thank you.

    Error
    SQL query:

    CREATE TABLE wp1q_layerslider (

    id INT( 10 ) NOT NULL AUTO_INCREMENT ,
    author INT( 10 ) NOT NULL DEFAULT ‘0’,
    name VARCHAR( 100 ) COLLATE utf8mb4_unicode_520_ci DEFAULT ”,
    slug VARCHAR( 100 ) COLLATE utf8mb4_unicode_520_ci DEFAULT ”,
    data MEDIUMTEXT COLLATE utf8mb4_unicode_520_ci NOT NULL ,
    date_c INT( 10 ) NOT NULL ,
    date_m INT( 10 ) NOT NULL ,
    schedule_start INT( 10 ) NOT NULL DEFAULT ‘0’,
    schedule_end INT( 10 ) NOT NULL DEFAULT ‘0’,
    flag_hidden TINYINT( 1 ) NOT NULL DEFAULT ‘0’,
    flag_deleted TINYINT( 1 ) NOT NULL DEFAULT ‘0’,
    PRIMARY KEY ( id )
    ) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci;

    MySQL said: Documentation

    #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Viewing 2 replies - 1 through 2 (of 2 total)
  • mdshak

    (@mdshak)

    9 years, 1 month ago

    Take the following steps to troubleshoot this issue.

    Open .sql file on any text file editor and go to “Search and Replace”.

    Find this “utf8mb4” and replace with “utf8”.

    It will replace the utf8mb4_unicode_ci to utf8_unicode_ci.

    Now you go to your PhpMyAdmin (destination) and set the DB collation to utf8_unicode_ci (Operations > Collation).

    sinip

    (@sinip)

    9 years, 1 month ago

    Server where you’re importing the database doesn’t support unicode 520ci collation. You can contact your hosting company and ask them to upgrade MySQL to 5.6 or above in order to support it, or convert the database to “standard” unicode. Here a nice guide – https://www.peterstavrou.com/fix-unknown-collation-utf8mb4_unicode_520_ci-error/

    • This reply was modified 9 years, 1 month ago by sinip.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘phpmyadmin database import error – #1273’ is closed to new replies.