/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 vote188 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote190 views1 answer
Print year of a date sql
SQL
1 vote178 views1 answer
T-sql find object by name
SQL
1 vote172 views1 answer
Oracle list datafiles in tablespace
SQL
1 vote185 views1 answer
Second last highest id in sql
SQL
13 votes186 views1 answer
Select count of distinct values sql
SQL
0 vote184 views1 answer
T-SQL Retry (deadlock)
SQL
16 votes220 views3 answers
T-SQL Add Column
SQL
0 vote189 views1 answer
Connect to nginx server mysql remotly
SQL
1 vote139 views1 answer
Full text index mysql
SQL