How to Solve the '#1273 – Unknown collation: 'utf8mb4_unicode_520_ci'' WordPress Database Error?

How to Fix '#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’' Error

WordPress users may encounter the perplexing error "#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’" when uploading their database from a local WAMP server to a live server. This error typically arises due to a mismatch between the MySQL versions running on the two servers.

Solution:

To resolve this issue, meticulous steps must be followed:

1. Open the SQL File:

   • Locate the SQL file associated with your database and open it using a text editor.

2. Find and Replace:

   • Within the SQL file, carefully search for all occurrences of "utf8mb4_unicode_520_ci" and diligently replace each instance with "utf8mb4_unicode_ci".

3. Save and Upload:

   • After making the necessary replacements, save your updated SQL file.
   • Then, proceed to upload this modified SQL file to a new and empty MySQL database on your live server.

By implementing these steps, the SQL commands in your database will become compatible with the live MySQL server, allowing for successful data transfer from your local WAMP environment.

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