29 July 2021 Thursday

WordPress ‘Unknown collation’ error

- Reklam -

When importing a WordPress site, you may receive errors as follows when importing on PhpMyAdmin (your. sql file).

#1273 – Unknown collation: ‘utf8mb4_unicode_ci’
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Now let’s overcome this problem together.

Firstly, this problem consists of MySQL version differences.

This problem can be overcome by updating the MySQL version. However, if your service provider does not allow it, you should do so with a different method.

Open the. sql file you will import with the ‘ Notepad + + ‘ application. You can download the Notepad + + application from the link here.

Open the Ctrl + F (Find operation) command. Replace all with values that will change the following values with the sequence.

Value sought: utf8mb4_unicode_ci value to change: utf8_general_ci

Value sought: utf8mb4_unicode_ci _ci value to change: utf8_general_ci

Value sought: utf8mb4 will change value: utf8

After you do these operations, save the file. You can now make the import process seamless.

- Reklam -
Ahmet Berat Adıgüzel
Ahmet Berat Adıgüzelhttps://www.paylasimpark.com
Since 2006, I have been interested in computers. I learned many languages ​​and methods on behalf of web design and program by means of research and trial and error. I studied Database Programming as a high school. As a college, I studied Computer Programming. I am pleased to share all my knowledge and experience with you.

İlgili Makaleler

GTA 6 Release Date And More

Rockstar Games is leading with the GTA series, and now after GTA 5, the company's new game, GTA 6, continues to reveal...

Here are Motorola Edge and Edge Plus Introduced

As we know, new members of the motorola family were introduced today on the day and officially presented all the features with...

iPhone 12/4 Model Will Come in Variant

Apple users are counting down the days for the new iPhone models, while Apple is leaking information about the models every day.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Sosyal Medya

289FansLike
205FollowersFollow
1,380SubscribersSubscribe

Son Makale

GTA 6 Release Date And More

Rockstar Games is leading with the GTA series, and now after GTA 5, the company's new game, GTA 6, continues to reveal...

Here are Motorola Edge and Edge Plus Introduced

As we know, new members of the motorola family were introduced today on the day and officially presented all the features with...

iPhone 12/4 Model Will Come in Variant

Apple users are counting down the days for the new iPhone models, while Apple is leaking information about the models every day.

Oppo A92S Viewed While Running

The company's New Phone, the Oppo A92S, is slowly showing off, and now it's operational, confirming that it has dual-hole camera technology....

Oppo A92s Features Leaked

Oppo is preparing to announce its new models. Posters of this phone appeared on the web. According to the images, the phone...