[solved] #1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

PHP & Mysql

I am facing this error #1273 - Unknown collation: 'utf8mb4_0900_ai_ci' when i am trying to import the database backup which i got from the server to my localhsot.
any thoughts on How can I figure out this issue?

#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

Comments

Jo Micheal

9 Jan 2022

Best Answer

You can handle this error by replacing the type of collation into the file,
you can search for “utf8mb4_0900_ai_ci” with “utf8mb4_general_ci” and “CHARSET=utf8mb4” with “CHARSET=utf8“.

so replace lines like

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

with

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Reference tecadmin.net

Terms & Conditions
Privacy Policy
Cookie Policy