Home >Database >Mysql Tutorial >How to Fix \'Unknown Collation \'utf8mb4_unicode_ci\'\' Error When Importing WordPress Database to 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:
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!