/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 vote199 views1 answer
Oracle temporary table
SQL
0 vote148 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote151 views1 answer
Hibernate dialect property xml for mysql 8
SQL
3 votes155 views1 answer
Oracle user privileges
SQL
0 vote157 views1 answer
Limit in access query
SQL
0 vote176 views1 answer
Check database restore status sql script
SQL
7 votes152 views2 answers
Execute mysql file
SQL
18 votes149 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote160 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote143 views1 answer
Sql exclude duplicates and find even id
SQL