How to solve import error #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

This error is caused because the local server and live server are running different versions of MySQL. To solve this:

  1. Open the sql file in your text editor
  2. Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
  3. Save and upload to a fresh mySql db
Was this answer helpful? 1 Users Found This Useful (2 Votes)