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'

Comments

Jo Micheal Date : 2022-01-09

Best answers

6

Best answers

6

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 

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

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

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

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

Tag: PHP & Mysql

ERROR 1410 (42000): You are not allowed to create a user with GRANT
Publish date: 2022-04-01 | Comments: 2

Tag: PHP & Mysql

SQL full languages table
Publish date: 2022-02-24 | Comments: 2

Tag: PHP & Mysql

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql