Med Okonta Med Okonta - 1 month ago 8
MySQL Question

Error importing database in phpmyadmin

I've been working on my site locally and i'm now trying to migrate it to a live. I export the local sql database and try to import it to the new database but it returns the error:

SQL query:

Table structure of table wpmedokonta_commentmeta

CREATE TABLE wpmedokonta_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'

Anyone know why this happens? Not sure if it helps but i'm not using comments anywhere in my site...

Answer

Probably this is because you have different MYSQL version. check if the version of local server is same as live server.