For Techs.... Techniques.... Technologies....


Mysql dump import error

Getting the following error while importing mysql database dump.

ERROR 1115 (42000): Unknown character set: 'utf8mb4'


As the message showing the current version of mysql not supporting the character set 'utf8mb4'. We need to upgrade the mysql for temporary resolving the problem.

utf8mb4 is a superset of utf8.

For fixing the problem temporarily,

  1. Open sql file by text editor
  2. Find and replace all utf8mb4 to utf8
  3. Import it again

That's all.....


Leave a Reply