/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 vote275 views1 answer
How to find columns with null values in sql
SQL
1 vote291 views1 answer
Update foreign key value in mysql
SQL
0 vote223 views1 answer
Finish transaction sql
SQL
0 vote279 views1 answer
Oracle create job if not exists
SQL
7 votes280 views1 answer
Oracle pagination query offset
SQL
0 vote269 views1 answer
Mysql grant user wildcard database
SQL
1 vote258 views2 answers
Difference between in and between in sql
SQL
0 vote266 views1 answer
Order by with where clause in mysql
SQL
1 vote257 views1 answer
Sql only five first row
SQL
0 vote331 views1 answer
Mysql get nested records
SQL