phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

This solution worked for me

1) Click the “Export” tab for the database

2) Click the “Custom” radio button

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

4) Scroll to the bottom and click “GO”.

If it’s related to wordpress, more info on why it is happening.

Leave a Comment