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

Your email address will not be published. Required fields are marked *