/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

2 votes310 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
10 votes318 views4 answers
Else if mysql
SQL
0 vote244 views1 answer
Postgresql add leading zeros
SQL
3 votes294 views1 answer
Oracle list invalid password ORA-01017
SQL
8 votes331 views6 answers
Sql insert
SQL
1 vote278 views3 answers
Mariadb add foreign key
SQL
2 votes294 views2 answers
Mysql limit
SQL
0 vote277 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote311 views1 answer
Psql show db
SQL
0 vote291 views1 answer
Call procedure in wordpress
SQL