I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the environment, I keep getting this error:
#1273 – Unknown collation: ‘utf8mb4_unicode_ci’
I have tried to Google around and the only solution I can find is this one phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’ which as by now isn’t much help. I have tried clearing the cookies but it still won’t work. Please help!
This method worked for me in this post: Click the \”Export\” tab for the database 2) Go the section \”Format-specific options\” and change the dropdown for \”Database system or older MySQL server\” to maximize output compatibility with: NONE to MYSQL40 to the bottom and click \”GO\”. I\’m not sure if this is the case, but I haven\’t tested a database exporter to save data in Black Studio TinyMCE Visual Editor widgets.
