/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 votes278 views1 answer
System.debug apex
SQL
25 votes352 views1 answer
How to update an attribute in MySQL
SQL
0 vote309 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
1 vote316 views1 answer
Postgresql export output table as a csv
SQL
3 votes313 views3 answers
Start postgresql ubuntu
SQL
17 votes304 views3 answers
Cast in sql server
SQL
8 votes316 views3 answers
Alter user root mysql
SQL
0 vote314 views1 answer
Mysql 1 hour ago
SQL
1 vote325 views1 answer
Myql find duplicates
SQL
4 votes315 views2 answers
Linq join
SQL