3 working ways to fix "unknown collation "utf8mb4_unicode_520_ci"" error

Why I am suddenly getting “unknown collation ‘utf8mb4_unicode_520_ci’” error?Well that’s the same question I had when I encountered this problem while migrating my trang web server. When I dig into the detail I found a solution for this problem. If you are facing the same problem then stay around & I will nội dung 3 working ways khổng lồ fix unknown collation ‘utf8mb4_unicode_520_ci‘ error that really works.

Bạn đang xem: 3 working ways to fix "unknown collation "utf8mb4_unicode_520_ci"" error

Why “unknown collation ‘utf8mb4_unicode_520_ci‘” error occurs?

This error generally occurs when you are trying khổng lồ migrate database server from a newer version to lớn an older version. MySQL servers higher than 5.6 versions tư vấn ‘utf8mb4_unicode_520_ci’ collation. If your destination server is having lower version than 5.6 then it does not support ‘utf8mb4_unicode_520_ci’ collation và you will get this error message.

How khổng lồ fix “unknown collation ‘utf8mb4_unicode_520_ci’”?

Here is the các mục of 3 different working ways that you can use to fix the unknown collation ‘utf8mb4_unicode_520_ci’error message.Try these methods one by one and see which one works for you.

Xem thêm: Top 6 Phần Mềm Chuyển Pdf Sang Word Chuyên Nghiệp, Phần Mềm Chuyển Đổi Pdf Sang Word

1. Change MYSQL vps version

As this issue is primarily because of MYSQL server version then upgrading your hệ thống to higher & latest version is the easiest and recommended way of getting rid of this error message.Higher version by mặc định supports ‘utf8mb4_unicode_520_ci’ & it will ensure higher data security và integrity for your trang web data. But if you don’t want to lớn upgrade the MYSQL hệ thống version, there are other ways to lớn resolve the error. You can still fix the issue by using other following methods.Also Read: MySQL ERROR 1046 (3D000) No Database Selected

2. Update database .sql file

Follow the below steps in order lớn update the .sql file for your database in the server.Locate the .sql file
Select .sql tệp tin > Right Click > Edit with Notepad++Press Ctrl + H. Find all occurrences of utf8mb4_unicode_520_ci & replace it with utf8mb4_unicode_ci
Save the .sql file and try to lớn reimport the database again. You should able khổng lồ import the database without any error message.

3. Using PHPMyAdmin

If you are using PHPMyAdmin to manage your database then you can easily get rid of this error message. Here are the steps to resolve unknown collation ‘utf8mb4_unicode_520_ci’ error message using PHPMyAdmin.Open PHPMyAdmin and click on Export tabIn the Export Method section select Custom optionGo khổng lồ the section “Format-specific options” và in the “Database system or older MySQL hệ thống to maximize output compatibility with” option select MYQL40 from the dropdown list.Click on Go button.This should fix the error while importing the database server.

Final thoughts:

We hope that with the above steps, you are able to lớn resolve the “unknown collation ‘utf8mb4_unicode_520_ci’” error message and able khổng lồ migrate the database successfully from source to the target environment.Do chia sẻ your experience of using above methods in the comment section and let other fellow readers know which method really worked for you.Cheers!
Click to giới thiệu on LinkedIn (Opens in new window)Click to tóm tắt on WhatsApp (Opens in new window)Click to chia sẻ on Reddit (Opens in new window)Click to share on Pinterest (Opens in new window)Click to chia sẻ on Telegram (Opens in new window)

Chuyên mục: Domain Hosting