Today, old Zuo is preparing to migrate the website of a customer from the company to another server, and back up the latest webpage files and export the database according to the normal operation, then, create a site and database wget on the new server and migrate it to and decompress it. Because the database is small, you can directly use PHPMyAdmin to import data online. However, the error message "#1115-Unknown character set: 'utf8mb4'" is displayed '".
1. Error message
It seems that the problem is caused by the database version. I can see that MYSQL5.1, a previous website version, is MYSQL5.5, and utf8mb4 is used since 5.5, while our database version is still the old utf8 version.
2. Solution
We use sublime to open the database and modify utf8mb4 to utf8.
3. Re-import the MySQL database
In this way, we can re-modify the database encoding and then import it to the MySQL database of a later version. This problem can be solved.
