Ayad knowledge base

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”.

I’m not certain if doing this causes any data loss, however in the one time I’ve tried it I did not notice any. Neither did anyone who responded in the forums linked to above.

 

Reference

http://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel/29939906#29939906

This entry was posted on Thursday, May 4th, 2017 at 4:29 am and is filed under Linux. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.