Wordpress 'Unknown collation' error - Paylaşım Park
Programming

WordPress ‘Unknown collation’ error

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.

Tags
Show More

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button