mysqldump¤Ïdump½èÍý¤ò̵ÍýÌðÍýutf8¤ËÊÑ´¹¤·¤Æ¹Ô¤¦¤Î¤Ç¡¢utf8°Ê³°¤Îʸ»ú¥³¡¼¥É¤ò»È¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¶ñ¹ç¤¬°¤¤¡£
¤½¤³¤Ç¡¢mysqldump¤Ëdump»þ¤Îʸ»ú¥³¡¼¥É¤ò»ØÄꤹ¤ëɬÍפ¬¤¢¤ë¤¬¡¢¤½¤ÎÊýË¡¤Ï²¼µ¤Î£²Ä̤ꡣ
1)my.cnf¤òÊÔ½¸¤·¤Æ¤â¤è¤¤¾ì¹ç¡Êmysqld¤òºÆµ¯Æ°¤Ç¤¤ë¾ì¹ç¡Ë
my.cnf¤Ë²¼µ¤òµºÜ¤¹¤ë
[mysqldump]
default-character-set=»ÈÍѤ¹¤ëʸ»ú¥³¡¼¥É
2)my.cnf¤òÊÔ½¸¤Ç¤¤Ê¤¤¾ì¹ç¡Êmysqld¤òºÆµ¯Æ°¤Ç¤¤Ê¤¤¾ì¹ç)
¼«Ê¬¤Î¥Û¡¼¥à¥Ç¥£¥ì¥¯¥È¥ê¤Ë .my.cnf ¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤òºî¤ê1)¤ÈƱ¤¸ÀßÄê¤òµ½Ò¤¹¤ë
dump¤¹¤ë´Ä¶¤È¥ê¥¹¥È¥¢¤¹¤ë´Ä¶¤Îʸ»ú¥³¡¼¥É¤¬Æ±°ì¤Ç¤¢¤ë¾ì¹ç¤Ï»ÈÍѤ¹¤ëʸ»ú¥³¡¼¥É¤ò»ØÄꤹ¤ë¤è¤ê¤âbinary»ØÄê¤ÎÊý¤¬³Ú¡£
[mysqldump]
default-character-set=binary