/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

-1 vote117 views1 answer
Spring boot mysql connection properties
SQL
0 vote177 views1 answer
Mysql update all record removing 2 hours from column
SQL
6 votes97 views2 answers
Find mysql version linux
SQL
2 votes105 views1 answer
Mysql query unique column
SQL
2 votes101 views1 answer
Oracle current date without time
SQL
0 vote124 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote113 views1 answer
How to check event scheduler status mysql
SQL
1 vote114 views1 answer
Default
SQL
-1 vote115 views2 answers
Full join sql
SQL
0 vote118 views1 answer
Get a list of tables and the primary key
SQL