Home >Database >Mysql Tutorial >How to Fix \'Unknown Collation \'utf8mb4_unicode_ci\'\' Error When Importing WordPress Database to cPanel?

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

DDD
DDDOriginal
2024-11-03 01:02:29340browse

How to Fix

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn