How to Resolve the \'Unknown Collation\' Error (#1273) During Database Import on cPanel?

Resolving Unknown Collation Error (#1273) During Database Import on cPanel

When attempting to import a MySQL database into a hosted phpMyAdmin environment on cPanel, users may encounter the following error:

#1273 - Unknown collation: 'utf8mb4_unicode_ci'

To address this issue, follow these steps:

1. Navigate to the "Export" tab within the database's management interface.
2. Select the "Custom" radio button.
3. Locate the "Format-specific options" section and change the "Database system or older MySQL server to maximize output compatibility with:" dropdown from "NONE" to "MYSQL40".
4. Scroll down and initiate the export process by clicking "GO".
5. Import the exported database into the cPanel environment.

It is recommended to export databases in this manner to prevent data loss caused by incompatible collation options. However, certain widgets (e.g., Black Studio TinyMCE Visual Editor widgets) may be affected by this export method, so additional testing is advised.

The above is the detailed content of How to Resolve the \'Unknown Collation\' Error (#1273) During Database Import on cPanel?. For more information, please follow other related articles on the PHP Chinese website!