1273 - Unknown collation: 'utf8mb4_unicode_ci' error
Posted by: Paolo Bergomi
Date: May 04, 2015 10:30AM

Hi all
I have a strange error coming up when importing sql db file from local db on my computer to the live mysql db.
some details
my local db has this features@:

Server general collation. Utf8_general_ci
Server: Mysql Wampserver
Server type: mysql
Server version: 5.6.17 mysql community server (GPL)
Protocolo version> 10.
User : root@localhost
Server charset: UTF -8 Unicode (utf8)

My live db has 5.0 version installed.
the error is this one (complete)

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 =50;

1273 - Unknown collation: 'utf8mb4_unicode_ci' error

Is maybe a issue with a old version installed? (in live db?)

I am managing a wordpress platform using a mysql db.
this error prevents me to update the live db, i cannot complete the import. the update stops as soon as the finds a table with the uknown collation utf8mb4_unicode_ci

I am ready to provide further info if requested
Thanks in advance for help

Options: ReplyQuote

Written By
1273 - Unknown collation: 'utf8mb4_unicode_ci' error
May 04, 2015 10:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.