when DB imported – How To: Fix Unknown Collation: ‘utf8mb4_unicode_520_ci’

By Category :

database file upload error

In this case I did replace some code in DB file:

  1. Open exported somebase.sql on text editor
  2. Find and replace “utf8mb4_unicode_520_ci” to “utf8_unicode_ci”
  3. Second replacement is “utf8mb4” to “utf8”
  4. Try import DB againe

some sources talk about replacement to “utf8_general_ci”

usefully links are:

https://core.trac.wordpress.org/ticket/38290

https://help.serversaustralia.com.au/hc/en-us/articles/115002504183-How-To-Fix-Unknown-collation-utf8-unicode-520-ci-

https://stackoverflow.com/questions/42385099/1273-unknown-collation-utf8mb4-unicode-520-ci

https://dba.stackexchange.com/questions/76788/create-a-database-with-charset-utf-8

 

Author :