MySQL errors: Unknown collation ‘utf8mb4_unicode_ci’, Unknown character set ‘utf8mb4’
I got these errors after I started to transfer dump databases from one server (fresh MySQL version) to another (older MySQL version). In an amicable way, I need to update the MySQL version to a fresh one. there are several more sites on the server, let’s perform the following manipulations.
Fixing error ERROR 1273 Unknown collation: ‘utf8mb4_unicode_ci’
Open the database dump in a text editor and replace
utf8mb4_unicode_ci
on
utf8_general_ci
Fixing ERROR 1115 Unknown character set: ‘utf8mb4’
Open the database dump in a text editor and replace
utf8mb4
on
utf8