/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 votes195 views2 answers
Truncate table
SQL
25 votes184 views6 answers
Import mysql database command line
SQL
19 votes194 views6 answers
Mysql if null
SQL
0 vote217 views1 answer
Time data type in mysql
SQL
-1 vote181 views2 answers
How to display top 50 rows?
SQL
1 vote192 views1 answer
Update mysql centos
SQL
0 vote221 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote195 views1 answer
Tsql table column constraint must be uppercase
SQL
6 votes178 views3 answers
Can you update NULL in sql
SQL
0 vote183 views1 answer
Postgresql extract hour and minutes from timestamp
SQL