MySQL Import error - Unknown collation: 'utf8mb4_unicode_520ci_'

Question

Here is the Error Message I can't import my sql file .

Please include the text of the error and some additional details. Otherwise this question is poor quality and will be closed. http://stackoverflow.com/help/how-to-ask — Dan, Dec 30 '16 at 19:11
Your error is that your browser don't know what is `utf8mb4_unicode_520ci` what is the version of your mysql? — Dekel, Dec 30 '16 at 19:11

score 2 · Answer 1 · edited May 23 '17 at 12:01

2

You should change collation utf8mb4_unicode_ci to utf8_general_ci. One way to do this is provided here.

You can also edit the sql file and replace ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci with ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

edited May 23 '17 at 12:01

Community

1
1

answered Dec 30 '16 at 19:17

Alexei - check Codidact

22,016
16
145
164

score 0 · Answer 2 · edited Apr 17 '20 at 02:56

0

open .sql file and rome

INGINE=InnoDB AUTO_INCREMENT=8193 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

manually and it will work

edited Apr 17 '20 at 02:56

Willie Cheng

7,679
13
55
68

answered Apr 16 '20 at 23:50

Hasanin Alsabounchi

1
1

score 0 · Answer 3 · answered May 28 '21 at 06:11

Before editing .sql file. Have a look at the version between both(backup and restore) of your MySQL. It was a version issue in my case. If you manage to get it on the same version, it solves the issue in most cases. If not then go for other recommended ways.

score 0 · Answer 4 · answered Nov 15 '22 at 18:38

You need to replace charset "utf8mb4" with "utf8" and COLLATE "utf8mb4_unicode_520ci" in your case with "utf8_general_ci".

You can achieve the replacement in MAC with below sed command. In Linux remove ''.

sed -i '' s/utf8mb4_unicode_520ci/utf8_general_ci/g NEW-CLEANED-DUMP.sql

sed -i '' s/utf8mb4/utf8/g NEW-CLEANED-DUMP.sql

MySQL Import error - Unknown collation: 'utf8mb4_unicode_520ci_'

4 Answers4

Linked