ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci”

Date Posted: 04-10-2017

Recently, when we tried to resource the dump which we had taken on one server and tried to restore it on another server. The restore failed with an error:

ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci”

Cause:

This issue could possibly happen when you restore mysqldump. This is because different mysql versions are used in source and destination server.

Resolution:

To fix this issue, Search all occurrences of utf8mb4_unicode_520_ci and replace it with utf8mb4_unicode_ci

replace utf8mb4_unicode_520_ci utf8mb4_unicode_ci -- mydump.sql

 

Post Views: 182

Leave a Reply