ERROR 1273 (HY000) at line 168: Unknown collation: ‘utf8mb4_0900_ai_ci’

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