Search code examples
mysqldatabasewordpressphpmyadminmigration

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...

Solution

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