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

5

Best answers

5

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

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql

How the image file have .php extension?
Publish date: 2022-03-01 | Comments: 2

Tag: PHP & Mysql

CodeIgniter route does not work
Publish date: 2022-02-22 | Comments: 4

Tag: PHP & Mysql

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql

mysql service start not exist
Publish date: 2022-02-23 | Comments: 4

Tag: PHP & Mysql