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 

import error 

in your .sql file, and swapping it with
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;


comment out containing this line code

GTID_PURGED