/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 vote266 views1 answer
Plsql check for string in numeric
SQL
2 votes275 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
15 votes294 views3 answers
Mysql update add to existing value
SQL
0 vote276 views1 answer
Mariadb datetime change to microseconds
SQL
-3 votes288 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
13 votes255 views2 answers
Check if value is null mysql
SQL
4 votes265 views3 answers
Oracle sql first day of quarter
SQL
0 vote284 views1 answer
How to map sql column to custom names
SQL
0 vote248 views1 answer
How to to get current date and time in sql
SQL
0 vote274 views1 answer
How much space does sql server take per row
SQL