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
Sidebar