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

Popular posts from this blog

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -