Error importing database

[Ixinho]

Hello i’m moving my database from hosting i shared with you
ixinho.admins.rs
user: ixinho
pass: delija

to a new hosting. I backedup databse in phpmyadmin, and now when i want to import it to a new hosting i get this sql error . . any idea what could cause it?

Error
SQL query:

— ——————————————————–
—
— Table structure for table wp_commentmeta
—
CREATE TABLE IF NOT EXISTS wp_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 = MYISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci AUTO_INCREMENT =1;

MySQL said: Documentation

#1273 – Unknown collation: ‘utf8mb4_unicode_ci’

[Veena]

Pls go through this thread –

https://wordpress.org/support/topic/sql-error-when-importing-database-1

[Ixinho]

Sorry, i already resolved it myself, it was encoding problem, i had to manually change encoding for all tables because mysql version of the destination hosting was sooo old. Thank you anyway Phoenix, and sorry for posting non wp related question. i thought it’s some plugin that is killing it ..

[Author]

Posts