unknow collation: ‘utf8mb4_0900_ai_ci’

Question

Hi! Good day. How can I import the version 14.2 database into a local environment? MySQL send error unknow collation: &lsquo;utf8mb4_0900_ai_ci&rsquo; Please can help me. Thanks!

Eduardo Carrasco · Answer

Kortnee Wilson it seems like Eduardo Carrasco 's MySQL 8.2 has been upgraded in place or something along those lines. I did install MySQL 8.2 (through docker) and it does have that collation and I managed to import a SugarCloud cloud 14.2 backup to my local environment without issues. 
 My suggestion is to Eduardo Carrasco work with his DBA team to have that collation installed (if that's a thing) or simply use containers for this by using our SugarDockerized as his local development environment.