ERROR 1273 (HY000) at line 336: Unknown collation: ‘utf8mb4_0900_ai_ci’

Luego de exportar la base de datos de MySql 8 y de querer importarla a MySql 5.7 me sale ese error, para solucionarlo hay que reemplazar la colación:

sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' crm.sql

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments