mysql - ERROR 1115 (42000): Unknown character set: 'utf8mb4' -
i have mysql dump, tried restore with:
mysql -u"username" -p"password" --host="127.0.0.1" mysql_db < mysql_db however, threw error:
error 1115 (42000) @ line 3231: unknown character set: 'utf8mb4' this lines 3231-3233:
/*!50003 set character_set_client = utf8mb4 */ ; /*!50003 set character_set_results = utf8mb4 */ ; /*!50003 set collation_connection = utf8mb4_general_ci */ ; i using mysql 5.1.69. how can solve error?
your version not support character set, believe 5.5.3 introduced it. should upgrade mysql version used export file.
the error quite clear: set character set in code, mysql version not support it, , therefore not know it.
according https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html :
utf8mb4 superset of utf8
so maybe there chance can make utf8, close eyes , hope, depend on data, , i'd not recommend it.
Comments
Post a Comment