/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

3 votes211 views1 answer
How to get list of synonyms in oracle
SQL
7 votes259 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote248 views1 answer
Sql datediff month
SQL
0 vote255 views1 answer
Sauvegarde complète my sql
SQL
0 vote288 views1 answer
Oracle chain step succeeded
SQL
0 vote247 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote268 views1 answer
How to search query in python3 sqlite3
SQL
23 votes284 views5 answers
Sql substring
SQL
1 vote310 views1 answer
Best configuration for display table in sqlplus
SQL
1 vote262 views1 answer
Mysql current time
SQL