Please help! Migrating site

  • Hi
    I am carefully following the steps to migrate my wordpress site, and I got this error when I try to import the sql in, please help!

    Error

    SQL query:

    #
    # Table structure of table wp_commentmeta
    #
    CREATE TABLE wp_commentmeta (
    meta_id bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
    comment_id bigint( 20 ) unsigned NOT NULL DEFAULT ‘0’,
    meta_key varchar( 255 ) COLLATE utf8mb4_unicode_ci DEFAULT NULL ,
    meta_value longtext COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key ( 191 ) )
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

    MySQL said: Documentation
    #1273 – Unknown collation: ‘utf8mb4_unicode_ci’

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter LEVI44

    (@levi44)

    anyone pls?

    Thread Starter LEVI44

    (@levi44)

    now i am getting

    #1046 – No database selected

    Error

    SQL query:

    # ——————————————————–
    # ——————————————————–
    # Table: wp_aps_social_icons
    #
    # Delete any existing table wp_aps_social_icons
    #
    DROP TABLE IF EXISTS wp_aps_social_icons ;

    MySQL said: Documentation
    #1046 – No database selected

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Please help! Migrating site’ is closed to new replies.