1273 - Unknown collation: 'utf8mb4_unicode_ci' error

[Paolo Bergomi]

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
Paolo