a problem with importing database online

  • after uploading my website using “filezilla” and exported my database from phpMyAdmin with sql extention , I compressed it to gzip , but when I want to import it to online server it gave me an error

    “

    Error
    SQL query:

    —
    — Database: wordpress
    —
    — ——————————————————–
    —
    — Table structure for table wp_aiowps_events
    —
    CREATE TABLE wp_aiowps_events (

    id BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
    event_type VARCHAR( 150 ) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
    username VARCHAR( 150 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    user_id BIGINT( 20 ) DEFAULT NULL ,
    event_date DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    ip_or_host VARCHAR( 100 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    referer_info VARCHAR( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    url VARCHAR( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    event_data LONGTEXT COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY ( id )
    ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci AUTO_INCREMENT =1;

    MySQL said: Documentation

    #1273 – Unknown collation: ‘utf8mb4_unicode_ci’

    ”

    if anyone know why I have this error tell what I can do ?

Viewing 6 replies - 1 through 6 (of 6 total)
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘a problem with importing database online’ is closed to new replies.