mysql vers mariadb : COLLATION 'utf8mb3_general_ci' is not valid for CHARACTER SET 'utf8mb4

Erreur 1: COLLATION 'utf8mb3_general_ci' is not valid for CHARACTER SET 'utf8mb4

Pour ressourdre ce probleme, il faut remplacer 'utf8mb3_general_ci' par 'utf8mb4_general_ci', sous linux vous pouvez le faire via la commande 'sed'. 

sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_general_ci/g' db-name-file.sql
Profile picture for user admin
Stephane K
Il y'a 3 months
Modifié
Il y'a 1 month
Loading ...