unknown collation 3a 27utf8mb4 0900 ai ci 27

1I believe this error is caused because the local server and live server are running different versions of MySQL. To solve this:
2
3Open the sql file in your text editor
4Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
5Save and upload to a fresh mySql db

1ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
2replace with
3ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

1search utf8mb4 change with utf8 
2search utf8mb4_unicode_ci change with utf8_unicode_ci