/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 votes127 views1 answer
Show index table
SQL
16 votes131 views4 answers
Mysql import from sql file
SQL
1 vote150 views1 answer
Sql in array query
SQL
0 vote113 views1 answer
Cara menampilkan user di mysql terminal
SQL
16 votes135 views3 answers
T-SQL Add Column
SQL
31 votes136 views2 answers
Grant all priviledges to mysql user
SQL
0 vote123 views2 answers
Functions with parameters SQL
SQL
0 vote122 views1 answer
Group by sql not ordering issues
SQL
5 votes135 views1 answer
Oracle list packages
SQL
0 vote125 views1 answer
Equi joins in oracle
SQL