Hello, I have the same problem but am VERY new to php and sql databases. I can follow instructions though.
I am getting the same error when I try to import my database utf8mb4 to utf8.
I know this is a “resolved” topic but I dont know how to make the changes that are recommend by fbimalayil above.
My error is below.
—
Error
SQL query:
—
— Database: clearly1_wp638
—
— ——————————————————–
—
— Table structure for table wpgv_commentmeta
—
CREATE TABLE IF NOT EXISTS wpgv_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 AUTO_INCREMENT =1;
—