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
                      
                    

Related Posts