Commonly this error occurred due to difference in local server and live server are running different versions of MySQLyou only need  to find and replace all utf8mb4_0900_ai_ci with utf8_general_ci

Replace the following string in your whole .sql  file

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

with:

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;