Solve the problem of importing MySQL database prompt \\"Unknown character set: \\’utf8mb4\\’\\" error

Today Snail is preparing to migrate the website of one of the company's customers to another server. It backs up the latest web page files and exports the database according to normal operations, and then creates the site and database in the new server and migrates them with wget to decompress them. Because the database is relatively small, I directly imported it online using the PHPMyAdmin tool, but I saw an error message \\”#1115 – Unknown character set: \\’utf8mb4\\’\\”.

First, error message

It seems to be caused by a problem with the database version. I saw that the previous website version MYSQL5.1 is now MYSQL5.5. Starting from 5.5, it uses utf8mb4, but our database version is still the old utf8.

Second, solution

We use sublime to open the database, and then change utf8mb4 to utf8.

Third, re-import the MySQL database

In this way, we can import it into a higher version of MySQL database after re-modifying the database encoding. This problem will be solved.

Recommended site searches: US host ranking, how to register a Chinese domain name, free cloud computer host permanent use, foreign vps server rental, Japanese server free, proxy IP address, domain name query official website, dual-line space, Dongguan server rental, US defense Attack the server,