MySQL dump error ‘illegal mix of collations' : It occurs by comparing two strings of incompatible collations. We need to make the two columns collation match.