CODEWITHSUNDEEP
mysqlwordpressdata-import
ShaonPro
ShaonPro

Reputation: 9

MySQL Import error - Unknown collation: 'utf8mb4_unicode_520ci_'

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

Upvotes: -1

Views: 16277

Answers (4)

Susil Parida
Susil Parida

Reputation: 400

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

Upvotes: 0

One Mad Geek
One Mad Geek

Reputation: 529

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.

Upvotes: 0

Hasanin Alsabounchi
Hasanin Alsabounchi

Reputation: 1

open .sql file and rome

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

manually and it will work

Upvotes: 0

Alexei - check Codidact
Alexei - check Codidact

Reputation: 23088

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

Upvotes: 2

Related Questions