/SQL/Unknown collation: 'utf8mb4_0900_ai_ci'

Unknown collation: 'utf8mb4_0900_ai_ci'

I believe this error is caused because the local server and live server are running different versions of MySQL. To solve this:

Open the sql file in your text editor
Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
Save and upload to a fresh mySql db

Unknown collation: 'utf8mb4_0900_ai_ci' stackoverflow

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
replace with
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Source: stackoverflow.com

Unknown collation: 'utf8mb4_0900_ai_ci'

search utf8mb4 change with utf8 
search utf8mb4_unicode_ci change with utf8_unicode_ci

-1

Similar codes

0 vote224 views1 answer
Mysql bind-address default value
SQL
10 votes187 views4 answers
Primary key sql
SQL
3 votes187 views3 answers
Create a view postgres
SQL
0 vote226 views1 answer
Html css mobile menu arrow dropdown
SQL
1 vote175 views3 answers
Java.sql.sqlexception: access denied for user
SQL
36 votes202 views3 answers
Add column in mysq
SQL
0 vote175 views1 answer
Sql examples from your work
SQL
0 vote192 views1 answer
How to delete python anywhere mysql database
SQL
-1 vote183 views1 answer
Mysql order by on condition
SQL
0 vote272 views1 answer
Python mysql check if database exists
SQL