Server mysql database import problem #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

0
116

Server mysql database import problem #1273 – Unknown collation:’utf8mb4_unicode_520_ci’

Export Database System

1) Select Local Host Phpmyadmin and Click the “Export” tab for the database

2) After go Export -> Click the “Custom” radio button

3) Then you will see the section titled called “Format-specific options” and change the dropdown for “Database system or older MySQL server to maximize output compatibility with:” from NONE to MYSQL40.

4) Finally -> Scroll to the bottom and click “GO” and Export your Database from Local Host.

If you use WordPress CMS the follow step – wp-config.php> Database DB_CHARSET default to “utf8”