How to Fix \'Unknown Collation \'utf8mb4_unicode_ci\'\' Error When Importing WordPress Database to cPanel?

Database Error: #1273 - Unknown Collation 'utf8mb4_unicode_ci' in cPanel

When attempting to import a WordPress database from a local machine to a hosted phpMyAdmin on cPanel, users may encounter the following error:

#1273 - Unknown collation: 'utf8mb4_unicode_ci'

This issue typically occurs when the database created on the local machine uses the UTF-8 character set with a specific collation, while the database on cPanel may have a different character set or collation configuration.

To resolve this error, follow these steps:

1. Open the database you want to export from your local machine in phpMyAdmin.
2. Click on the "Export" tab.
3. Select the "Custom" radio button.
4. Scroll down to the section titled "Format-specific options."
5. Change the dropdown for "Database system or older MySQL server to maximize output compatibility with:" to "MYSQL40."
6. Scroll to the bottom and click "GO."

Exporting the database in this manner should resolve the collation issue and allow you to import it into cPanel's phpMyAdmin.

The above is the detailed content of How to Fix \'Unknown Collation \'utf8mb4_unicode_ci\'\' Error When Importing WordPress Database to cPanel?. For more information, please follow other related articles on the PHP Chinese website!