That’s the common error I have when I am trying to dump my local sql file to my server. Here is a quickfix

In your SQL file replace this line :

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

With this new one :

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Be sure to replace those content too

utf8mb4_0900_ai_ci
utf8mb4_general_ci

And this content too 

CHARSET=utf8mb4
CHARSET=utf8