Database Migration Error

[pakgalaxy]

i have exported mysql database from Klox-MR.
Now i am going to import it on Mysql 5.1 ver, it gives error.
MySQL said: Documentation

#1115 - Unknown character set: 'utf8mb4'

What should i do now?

[ebokalsel]

as far as i google it, mysql 5.1 doesn't support utf8mb4. Upgrade it to mysql 5.5 or change charset before exporting database ^_^

[MRatWork]

So, how to make you can use mysql 5.1.

[pakgalaxy]

as far as i google it, mysql 5.1 doesn't support utf8mb4. Upgrade it to mysql 5.5 or change charset before exporting database ^_^

change charset before exporting database
i have already done this but useless

[pakgalaxy]

So, how to make you can use mysql 5.1.

its my client site database, who want to move other server having mysql 5.1 ver, What i have to do?

[MRatWork]

Open the .sql (dump) file and change 'DEFAULT CHARSET=utf8mb4;' to 'DEFAULT CHARSET=latin1;

[pakgalaxy]

Open the .sql (dump) file and change 'DEFAULT CHARSET=utf8mb4;' to 'DEFAULT CHARSET=latin1;

Code: [Select]

`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=3789 DEFAULT CHARSET=utf8;
What about this?

[pakgalaxy]

i have replaced
utf8mb4 with utf8
and
utf8mb4_unicode_ci with utf8_general_ci
then all the data perfectly imported.

Code: [Select]

`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=3789 DEFAULT CHARSET=utf8;