How To Solve Unknown collation: ‘utf8mb4_unicode_ci’ Error

Like I reminded you that you can get many unknown errors while you blogging or managing your website.The only good solution of this headache is to keep yourself updated with new changes.

This time it happens with your database which probably you didn’t expect.I have also got this error when I was trying to upload MySQL database through PhmMyadmin.The error was like – #1242 – Unknown collation: ‘utf8mb4_unicode_ci’

Now if you are very new blogger, I guarantee you will be frustrated seeing this message because you can’t understand what exactly it is ?Well if you search for solution on web you will get thousand answer which just boring and more confusing.

How to get rid of it ? This has very simple solution and it starts with Notepad++. Download notepad++ from their official website or any software downloading site free.

2. Now go to your .sql database and open using notepad++ (click on right mouse button and open it with notedpad++)

3.Select all(Ctrl+A) and find (Ctrl+F).Mb4 extention only.

4.Replace it keeping empty “replace with” value (note: you need to keep empty “replace with box empty to remove”

How To Solve Unknown collation 'utf8mb4_unicode_ci' Error

5. Now save the notepad (Ctrl+S)

Yeah !! you just kicked off the .Mb4 error and your database ready to be uploaded

Add Comment