\u3042\u308b\u30b5\u30a4\u30c8\u3067\u4f7f\u3063\u3066\u3044\u308bDB\u306e\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u3092\u3057\u305f\u3044\u3068\u8003\u3048\u3066\u3044\u307e\u3059\u3002DB\u304c\u306a\u305c\u304blatin1\u306echarset\u3067\u904b\u7528\u3055\u308c\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u306e\u3067\u3001UTF8\u306b\u3057\u305f\u3044\u306e\u3067\u3059\u304c\u3001\u306a\u304b\u306a\u304b\u96e3\u3057\u3044\u3088\u3046\u3067\u3059\u3002\u3068\u308a\u3042\u3048\u305a\u3001\u306a\u305c\u304b–default-character-set=latin1\u3092\u6307\u5b9a\u3057\u3066\u30c0\u30f3\u30d7\u3092\u3068\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
$ mysqldump -u root –default-character-set=latin1 -c -n db > db_latin.sql<\/p>\n
\u3053\u308c\u3092\u3001nkf\u306a\u3069\u3067\u5909\u63db\u3002\u30c7\u30fc\u30bf\u306fEUC-JP(ujis)\u306a\u306e\u3067\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067\u5909\u63db\u3067\u304d\u307e\u3059\u3002<\/p>\n
$ nkf -wE db_latin.sql > db_w.sql
\n$ sed ‘s\/CHARSET=utf8\/CHARSET=utf8\/g’ db_w.sql > db_utf8.sql<\/p>\n
SQL\u306e\u6700\u521d\u306e\u65b9\u3067set name latin1\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u305d\u3053\u3082utf8\u3068\u76f4\u3057\u307e\u3059\u3002\u305d\u306e\u3042\u3068\u3001\u30ea\u30b9\u30c8\u30a2\u3092\u3059\u308c\u3070\u3044\u3044\u306e\u3067\u3059\u304c\u3001\u5148\u306bdb_utf8\u3092\u7528\u610f\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n
$ mysql -u root db_utf8 -p
\nmysql> create database db_utf8 default character set utf8;<\/p>\n
\u3042\u3068\u306f\u3001\u30ea\u30b9\u30c8\u30a2\u3002
\n$ mysql -u root db_utf8 < db_utf8.sql\n\n\u3068\u3053\u308d\u304c\u3001\u300cGot a packet bigger than 'max_allowed_packet' bytes\u300d\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3002\u30d1\u30b1\u30c3\u30c8\u30b5\u30a4\u30ba\u304c\u5927\u304d\u3044\u3068\u3044\u3046\u4e8b\u306a\u306e\u3067\u3001\u30aa\u30d7\u30b7\u30e7\u30f3\u3067 --max_allowed_packet \u3092\u4f7f\u3048\u3070\u3044\u3044\u3089\u3057\u3044\u306e\u3067\u3059\u304c\u3001\u3046\u307e\u304f\u3044\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002\n\n$ mysql --max_allowed_packet=128M -u root db_utf8 < db_utf8.sql\n\nmy.cnf\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u3066\u5bfe\u5fdc\u3068\u3044\u3046\u624b\u3082\u3042\u308b\u3088\u3046\u3067\u3059\u304c\u3001\u3053\u3061\u3089\u306f\u8a66\u3057\u3066\u307f\u3066\u3044\u307e\u305b\u3093\u3002\n\n[mysqld]\n(\u7565)\nmax_allowed_packet=128M\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3042\u308b\u30b5\u30a4\u30c8\u3067\u4f7f\u3063\u3066\u3044\u308bDB\u306e\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u3092\u3057\u305f\u3044\u3068\u8003\u3048\u3066\u3044\u307e\u3059\u3002DB\u304c\u306a\u305c\u304blatin1\u306echarset\u3067\u904b\u7528\u3055\u308c\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u306e\u3067\u3001UTF8\u306b\u3057\u305f\u3044\u306e\u3067\u3059\u304c\u3001\u306a\u304b\u306a\u304b\u96e3\u3057\u3044\u3088\u3046\u3067\u3059\u3002\u3068\u308a\u3042\u3048\u305a\u3001\u306a\u305c\u304b–de … \u7d9a\u304d\u3092\u8aad\u3080