How to Fix the MySQL Error '#1273 – Unknown collation: 'utf8mb4_unicode_520_ci'”?

Fixing Unknown Collation Error on Live Server: #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

When attempting to transfer a WordPress database from a local WAMP server to a live server, users may encounter the error:

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

This error stems from a discrepancy in MySQL versions between the local and live servers. To resolve this issue, follow these steps:

1. Open the SQL file in a text editor: Navigate to the SQL file containing the database dump.
2. Find and replace: Locate every instance of utf8mb4_unicode_520_ci and replace it with utf8mb4_unicode_ci.
3. Save and upload: Save the modified SQL file and upload it to a clean MySQL database on the live server, ensuring that both servers are running the same version of MySQL.

By following these steps, you can eliminate the collation error and successfully import your WordPress database onto the live server, as illustrated in the accompanying image.

The above is the detailed content of How to Fix the MySQL Error '#1273 – Unknown collation: 'utf8mb4_unicode_520_ci'”?. For more information, please follow other related articles on the PHP Chinese website!