/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 vote278 views1 answer
Oracle sql developer script output limit
SQL
0 vote330 views1 answer
How to output a different column name in mysql
SQL
-1 vote317 views1 answer
Sql getdate date only
SQL
13 votes528 views4 answers
Sql joining 3 tables
SQL
1 vote348 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote314 views1 answer
Mysql command prompt date insert format
SQL
0 vote391 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote337 views1 answer
Max mysql
SQL
1 vote302 views1 answer
Foreign key in oracle sql developer
SQL
0 vote305 views2 answers
Avg() sql
SQL