Importing SQL database Error related to "table structure" for wp_commentmeta

When you create the new, empty database you need to make sure the collation set matches the collation of the old database. In PHPMyAdmin check the collation of the old database under Operations->Collation.

In your case, the new database seems to need to be set to utf8mb4_unicode_ci which can be done when you initially create the database. Once set, try importing again.

Thanks for your help. I played with the collation options, but I still can’t get it to import properly. I called the hosting company and they said the platform I was working on was too old. The new myadminphp reads the database just fine, so I am just going to going with that. I appreciate your input.

Old versions of MySQL do not know about utf8mb4. My advice would be to switch to get your host to upgrade the MySQL version, or switch to an alternate hosting service.

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.

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;
—