I exported the sql from an existing database for an existing site that's hosted on Bluehost.
I'd like to be able to import it into the development environment without hitting an issue; I'm flexible, I can change the MySQL version I'm using in the development environment; my goal is to make it as easy as possible to import the exported sql code into the development environment without all these errors. That said is there anything I can do about this? I keep getting the following:
ERROR 1273 (HY000) at line 2071: Unknown collation: 'utf8mb4_unicode_520_ci'
I'm using the mysql-server package
5.5.53-0ubuntu0.14.04.1 at present, I believe Bluehost uses
Is there a specified way of fixing this? Also if I were to import that data back into the site, would it cause an issue?