Migration failed - WordPress database error: [Unknown collation: 'utf8mb4_unicode_520_ci']

Support
1

Hi there,

Using Gravity Forms and Migrate DB Pro and when I try to migrate my Gravity Forms tables it fails due to the collation.

WordPress database error: [Unknown collation: ‘utf8mb4_unicode_520_ci’]
CREATE TABLE _mig_wpmtheme_rg_form ( id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, title varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL, date_created datetime NOT NULL, is_active tinyint(1) NOT NULL DEFAULT ‘1’, is_trash tinyint(1) NOT NULL DEFAULT ‘0’, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Looking in Sequel Pro, I can see there is no option for utf8mb4_unicode_520_ci.

Any idea how I can make this work?

Cheers,
Tracey

2

Oops, just saw a previous topic with a similar issue. I’ve set the default MySQL version to 5.6 in Settings so now I just need to know if it’s possible to change an existing one.

3

Unfortunately it’s not possible to change an existing site at this time but that will most likely come down the road :slight_smile:

4

Bump, is there a solution for this yet? I’m not using Gravity Forms, but same situation.

I’m able to push the database from Local to my server, but can’t pull it back, getting the same error as @TraceySin

5

Hi @flask,

When you set up a new site make sure you’re using MySQL 5.6.

7