WordPress

How to fix #1273 – Unknown collation: utf8mb4_unicode_520_ci

In this article, we are going to show you step by step How to fix #1273 – Unknown collation: utf8mb4_unicode_520_ci on PHPMyAdmin.

When you are importing database SQL file on the PhpMyAdmin then it is showing the unknown collation error. Are you struggling to import the database SQL file on your new host? If yes you have right place here. Hope this article would be helpful for you.

#1273 - Unknown collation: utf8mb4_unicode_520_ci on

utf8mb4_unicode_520_ci

Then this article only for you. After reading this article, you will able to solve this “utf8mb4_unicode_520” issue very easily.

Video Tutorial

if you don’t like the video or you need to more instructions then you can continue reading our blog post.

How to fix #1273 – Unknown collation: utf8mb4_unicode_520_ci?

First step: Firstly download the Notepad++ software from the link and install it on your computer. If you have already installed notepad++ on your pc then ignore the first step and move the 2nd step.

Download notepad++

Second step: Edit the database SQL file to use notepad++. Select the (your-db-

name.sql) file then click the right button –> Click Edit with notepad++

notepad++ edit

After clicking the edit with notepad++ button the database file  will appear on the display like below image

3rd step: From the top menu click Search –> Find or Press CTL+F

Find box will pop up on the display

4th Step: Now move the Replace tab. Then fill up the Find what & Replace with fields.

Find what: utf8mb4_unicode_520_ci

Replace with: utf8mb4_unicode_ci 

Finally, Click the Replace All button. Now all utf8mb4_unicode_520_ci replaced to utf8mb4_unicode_ci

Fifth Step: Now you should save the sql file. From top menu click the File —> Save or CTL+S.

6th step: Almost done. Now we should import the edited database SQL file . Go to the PHPMyAdmin –> Select the database —> Check all –> Drop

Press Yes

7th step: Select the Database –> Import—> chose file–> Select the sql file, which we edited early

Final step: Finally we have successfully imported the database.

If you think this article was very helpful for you then don’t forget to share this article and subscribe to our youtube channel. if you need any help then feel free contact me via Fiverr.com

Was it helpful?

About the author

Rakhibul Hasan

I am Rakhibul Hasan founder of WordPress tutorial for beginners. I am a professional Wordpress expert and full-time freelancer. I work at Fiverr. I am a Top-rated Seller on Fiverr. Already completed 3k+ projects and achieved 2k+ positive reviews. So you can contact me at any time via Fiverr.

Leave a Comment

four × 1 =