/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 vote102 views1 answer
Postgresql conectar
SQL
0 vote110 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote124 views1 answer
Migration graphql
SQL
9 votes113 views1 answer
Mysql check date range
SQL
4 votes127 views2 answers
Bulk kill mysql processlist
SQL
0 vote120 views1 answer
Search In the Data using ObjectName
SQL
0 vote115 views1 answer
Postgres jsonb array push new element
SQL
0 vote115 views1 answer
Sql join on a subquery
SQL
-1 vote130 views3 answers
PS5
SQL
0 vote117 views1 answer
Intellij mysql set timezone
SQL