Re: Cant import database correctly, collation mismatch
On the each machine do
SHOW CREATE DATABASE database_name;
See if the CHARACTER SET is the same.
When running mysqldump, explicitly state the character set to dump it in; see the args.
More discussion (mostly for background):
http://mysql.rjweb.org/doc.php/charcoll
Subject
Views
Written By
Posted
3806
May 24, 2012 06:34AM
Re: Cant import database correctly, collation mismatch
1428
May 26, 2012 10:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.