I had the same issue when uploading database to server.
Error
SQL query:
#
# Table structure of table <code>wp_commentmeta</code>
#
CREATE TABLE <code>wp_commentmeta</code> (
<code>meta_id</code> BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
<code>comment_id</code> BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
<code>meta_key</code> VARCHAR( 255 ) COLLATE utf8_unicode_520_ci DEFAULT NULL ,
<code>meta_value</code> LONGTEXT COLLATE utf8_unicode_520_ci,
PRIMARY KEY ( <code>meta_id</code> ) ,
KEY <code>comment_id</code> ( <code>comment_id</code> ) ,
KEY <code>meta_key</code> ( <code>meta_key</code> ( 191 ) )
) ENGINE = INNODB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_520_ci;
————–
I Just replace all utf8_unicode_520_ci with utf8_unicode_ci in database. Then im able to upload the database. This works for me.
You can try replace utf8mb4_unicode_ci with utf8_unicode_ci
-
This reply was modified 8 years, 2 months ago by fbimalayil.