user image

Joseph Morgan
Published in : 2022-01-09

[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'


Jo Micheal Date : 2022-01-09

Best answers


Best answers


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;




Leave a comment

Join us

Join our community and get the chance to solve your code issues & share your opinion with us

Sign up Now

Related posts

Warning appears in Zend framework
Publish date: 2022-02-24 | Comments: 1

Tag: PHP & Mysql

[solved] Storage engine 'InnoDB' does not support system tables
Publish date: 2022-01-09 | Comments: 0

Tag: PHP & Mysql

change user root privelige and password
Publish date: 2022-02-23 | Comments: 1

Tag: PHP & Mysql

Mysql query: How do I count the day streak of particular user?
Publish date: 2022-03-01 | Comments: 4

Tag: PHP & Mysql

(Mysql) Count User's signing in activity based on daily login logs
Publish date: 2022-11-05 | Comments: 0

Tag: PHP & Mysql

php difference between two times in hours
Publish date: 2022-02-25 | Comments: 2

Tag: PHP & Mysql

MySQL - Lost connection to MySQL server during query - Required a solution.
Publish date: 2022-03-03 | Comments: 1

Tag: PHP & Mysql