MySQL error: #1273 — Unknown collation: ‘utf8mb4_unicode_520_ci’

Here's a solution to the error that occurs when importing a MySQL database in phpMyAdmin.

In this case, you need to open the database using specialized programs like Notepad++ or Transmit on Mac OS. Then, find the lines containing 'utf8mb4_unicode_520_ci' and replace them with 'utf8mb4_unicode_ci.' Save the file and proceed with the import to your hosting.