Shulou(Shulou.com)05/31 Report--

This article mainly explains how to solve the error of Unknown collation: 'utf8mb4_unicode_ci' when WordPress is imported into the database. Interested friends may wish to take a look at it. The method introduced in this article is simple, fast and practical. Let the editor take you to learn how to solve the error of Unknown collation: 'utf8mb4_unicode_ci' when importing WordPress into database.

Starting from the WordPress4.2 version, if we export the data encoding in the MYSQL5.1 version with utf8mb4 format, if we move the website to recover the data, the "Unknown collation: 'utf8mb4_unicode_ci" error will occur when the high-version databases such as MYSQL5.5 are imported into the lower version of MYSQL5.1. This problem did not exist before, but only from WP4.2.

To solve this problem, if we use the VPS/ server, can be similar to the left yesterday's "MySQL5.1 upgrade to MySQL5.5 version in the Linux CentOS6 environment" method to upgrade the MYSQL database version, so that there will not be incompatibility problems, but if we use a virtual host or upgrade MYSQL there is some technical work, if dealing with errors is really troublesome. Here we can choose a compatible version when exporting the database.

First, backup data

We need to back up the website data from the existing host / server before upgrading and importing the data.

Second, export compatible version database

Enter PHPMYADMIN and look at the following interface when we export the database.

Resolve WordPress import database "Unknown collation: 'utf8mb4_unicode_ci" error

Starting from the WordPress4.2 version, if we export the data encoding in the MYSQL5.1 version with utf8mb4 format, if we move the website to recover the data, the "Unknown collation: 'utf8mb4_unicode_ci" error will occur when the high-version databases such as MYSQL5.5 are imported into the lower version of MYSQL5.1. This problem did not exist before, but only from WP4.2.

To solve this problem, if we use the VPS/ server, can be similar to the left yesterday's "MySQL5.1 upgrade to MySQL5.5 version in the Linux CentOS6 environment" method to upgrade the MYSQL database version, so that there will not be incompatibility problems, but if we use a virtual host or upgrade MYSQL there is some technical work, if dealing with errors is really troublesome. Here we can choose a compatible version when exporting the database.

First, backup data

We need to back up the website data from the existing host / server before upgrading and importing the data.

Second, export compatible version database

Enter PHPMYADMIN and look at the following interface when we export the database.

Select a custom export method.

Looking at the figure above, we have no problem selecting MYSQL40 in the maximum compatibility database option, then exporting the database and then importing it into a lower version of MYSQL. If there is a garbled problem, we will:

The copy code is as follows:

Define ('DB_CHARSET',' utf8mb4')

Change to

The copy code is as follows:

Define ('DB_CHARSET',' utf-8')

Because utf8mb4 needs to be compatible with version 5.5 and above, if we are newly installing the VPS website environment, it is recommended that we install / upgrade MYSQL directly to version 5.5 and above, so that such a problem will not occur.

At this point, I believe you have a deeper understanding of "how to solve the Unknown collation: 'utf8mb4_unicode_ci error in the WordPress import database". Here is the website, more related content can enter the relevant channels to query, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.