Error while uploading database from

  • Yunax Technologies

    (@yunaxtechnologies)


    9 years, 3 months ago

    [ Moved to the Fixing WordPress sub-forum. ]

    Hello,

    When I am trying to upload WordPress site database from WAMP phpmyadmin to liver server PHPmyadmin, But I unable to upload database and got this error message.

    ****************************************************************
    Error
    SQL query:

    --
    -- Database:     bcstax
    --
    -- --------------------------------------------------------
    --
    -- 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'

    ****************************************

Viewing 1 replies (of 1 total)
  • Arnel C.

    (@arncus)

    9 years, 3 months ago

    Hello,

    Sorry for the problems with the database issue. I would highly recommend simply using the export option and saving your database as a SQL file. Then you can transfer the SQL file (which is basically a text file) and import it to your online copy of the WordPress site.

    I hope this helps to answer your question, please let us know if you require any further assistance.

    Regards,
    Arnel C.

Viewing 1 replies (of 1 total)

The topic ‘Error while uploading database from’ is closed to new replies.