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.
