To fix a database you are uploading into Plesk with mariaDB - 

it looks like doing a find and replace of "utf8mb4_0900_ai_ci" with "utf8mb4_general_ci" (in the exported SQL file) may have worked, at least it imported without errors.