Error #1115 – Unknown character set: utf8mb4 This error occurred to me in the process of transferring the site and database from one hosting to another. More precisely, it appeared when I tried to import a database dump into phpMyAdmin.
Reasons for the error
MySQL on the new hosting does not support utf8mb4 encoding, which indicates the old version of MySQL.
Tips & Tricks:
Solution
1. Update the MySQL version
If you have a virtual server (VPS/VDS) you can upgrade MySQL to the latest version.
In this case, for each operating system on the server, using the console, the installation package is downloaded and the installation is performed.
For regular hosting, this option is not suitable. But, you can contact the hosting support and ask them to update the MySQL version.
2. Editing our database dump
Open the dump file in a text editor such as Notepad++.
Using the Find-Replace commands, we find utf8mb4 in the dump file and replace it with utf8.
Save the file and import it into phpMyAdmin.
Related items: