Thursday, June 4, 2015

Solve Unknown collation: 'utf8mb4_unicode_ci' Error in Wordpress

If you use Wordpress for Blog/Website or are you Wordpress developer than must know import and export database for upload website on live or move website from one server to another server.
If you want to change Wordpress website server live to local or move website than another server than first export old Wordpress database and than upload it to new server than sometimes you fetch below error in cpanel phpMyAdmin.

#1273 - Unknown collation: 'utf8mb4_unicode_ci'

This error because of change php version if php version is higher than 5.5 than it save all database as 'utf8mb4_unicode_ci' and that database import to lower version of cpanel than it's display below error. Solve that error just exporting database according to below step for import it on lower version of PHP.

1) Select database of phpmyadmin.
2) Click on 'Export' tab on database.
3) Select `Custom` Export Method.
4) Select tables from list of all database tables for export.
5) Select `Format-specific options`->'Database system or older MySQL server to maximize output compatibility with' MYSQL40 instead of NONE.
6) Click on GO button at bottom for export.
7) Save exporting database.

Now import new exporting database to new server it's install successfully.Here from below step 5th step is most important and compulsory for solve 'Unknown collation' error.

1 comment :