What happened: I had my blog hosted on SiteGround and my plan expired. I created a full website backup first which contained all the files including the public_html folder adn the databases associated with my WordPress blog.
The issue I'm having now is that I can't upload my databases on my current host (000WebHost) because it won't read the utf8mb4 encoded mysql files.
The error I get is:
1273 - Unknown collation: 'utf8mb4_unicode_ci'
I looked for ways to convert utf8mb4 encoding to utf8 but it all requires running a MySQL query and 1. I can't do that in MyPHPAdmin because I can't upload the database in the first place and 2. I don't know how to run it in the command line
Any suggestions? Have you been through this before? Thanks