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.
Then this article only for you. After reading this article, you will able to solve this “utf8mb4_unicode_520” issue very easily.
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.
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++
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
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