\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c 5.1 \u304b\u3089 5.7 \u306b\u4e0a\u304c\u3063\u305f\u3002
\n\u3053\u308c\u306b\u3088\u308a\u30014\u30d0\u30a4\u30c8UTF8\u6587\u5b57\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3002
\n\u3059\u306a\u308f\u3061\u7d75\u6587\u5b57\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3002
\n\u3053\u308c\u3092\u4f7f\u3044\u305f\u3044\uff01<\/p>\n
\u3067\u3082\u3001\u81ea\u52d5\u7684\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092 4\u30d0\u30a4\u30c8\u5bfe\u5fdcUTF-8 \u306b\u5909\u3048\u3066\u304f\u308c\u308b\u308f\u3051\u3067\u306f\u306a\u3044\u306e\u3067\u3001\u81ea\u5206\u3067\u305b\u3063\u305b\u3068\u5909\u66f4\u3059\u308b\u3002 <\/p>\n
\u4ee5\u4e0b\u3001\u5099\u5fd8\u9332\u3068\u3057\u3066\u624b\u9806\u3092\u8a18\u3057\u3066\u304a\u304f\u3002<\/p>\n
mysql<\/span>\u30b3\u30de\u30f3\u30c9\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u3053\u3061\u3089\u306e\u516c\u5f0f\u30b5\u30a4\u30c8\u306b\u8a73\u3057\u304f\u66f8\u304b\u308c\u3066\u3044\u308b\u3002 \u4eca\u56de\u4f7f\u7528\u3057\u305f\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002 \u307e\u305a\u306f DB\u306e character set \u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n \u7d9a\u3051\u3066\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30ab\u30e9\u30e0\u306e character set \u3092\u5909\u66f4\u3059\u308b\u3002 \u3042\u3068\u3067\u6e05\u66f8\u3057\u3088\u3046\u3002<\/p>\n (1) \u3084\u308a\u305f\u3044\u3053\u3068 \u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c 5.1 \u304b\u3089 5.7 \u306b\u4e0a\u304c\u3063\u305f\u3002 \u3053\u308c\u306b\u3088\u308a\u30014\u30d0\u30a4\u30c8UTF8\u6587\u5b57\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3002 \u3059\u306a\u308f\u3061\u7d75\u6587\u5b57\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3002 \u2026 \u7d9a\u304d\u3092\u8aad\u3080 »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[125,80],"tags":[],"class_list":["post-1339","post","type-post","status-publish","format-standard","hentry","category-db","category-mysql"],"views":5634,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts\/1339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/comments?post=1339"}],"version-history":[{"count":13,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts\/1339\/revisions"}],"predecessor-version":[{"id":3655,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts\/1339\/revisions\/3655"}],"wp:attachment":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/media?parent=1339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/categories?post=1339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/tags?post=1339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nhttps:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/mysql-command-options.html<\/a><\/p>\n
\n\n
–user=<\/span>user_name<\/td> -u<\/span> user_name<\/td> \u30e6\u30fc\u30b6\u30fc\u540d<\/td><\/tr> –database=<\/span>db_name<\/td> -D<\/span> db_name<\/td> \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d<\/td><\/tr> –password=<\/span>password<\/td> -p<\/span>password<\/td> \u30d1\u30b9\u30ef\u30fc\u30c9 \u203bp<\/b>\u306e\u5f8c\u306e\u7a7a\u767d\u6587\u5b57\u306fNG<\/span><\/td><\/tr> –execute=<\/span>statement<\/td> -e<\/span> statement<\/td> SQL\u30b3\u30de\u30f3\u30c9<\/td><\/tr>\n<\/table><\/p>\n 1) \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u6587\u5b57\u30b3\u30fc\u30c9\u3092 UTF8 \u304b\u3089 UTF8MB4 \u306b\u5909\u66f4\u3059\u308b\u3002<\/h3>\n
\r\nDATABASE=xxxxxx\r\nUSERNAME=yyyyyy\r\nPASSWORD=zzzzzz\r\n\r\nSQLCMD="ALTER DATABASE ${DATABASE} CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;" \r\nSHOWDH="show variables like \\"chara%\\";" \r\n\r\nmysql -u $USERNAME -D $DATABASE -p$PASSWORD -e "$SHOWDH" \r\nmysql -u $USERNAME -D $DATABASE -p$PASSWORD -e "$SQLCMD" \r\nmysql -u $USERNAME -D $DATABASE -p$PASSWORD -e "$SHOWDH" \r\n<\/pre>\n
\n\u30c0\u30f3\u30d7\u51fa\u529b\u3057\u3066\u4e00\u6c17\u306b\u7f6e\u63db\u30fb\u5909\u66f4\u3057\u3001\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u3002<\/p>\n\r\nDUMP1=mydb.dump\r\nDUMP2=mydb_new.dump\r\n\/usr\/local\/mysql\/bin\/mysqldump $DATABASE -h localhost -u $USERNAME -p$PASSWORD -e --single-transaction > $DUMP1\r\n\r\nsed -e "s\/CHARSET=utf8\/CHARSET=utf8mb4\/g" $DUMP1 > $DUMP2\r\n\r\nmysql -u $USERNAME -p$PASSWORD -D$DATABASE < $DUMP2\r\n<\/pre>\n
2) \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u4e2d\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u6307\u5b9a\u3092\u5909\u66f4\u3059\u308b\u3002<\/h3>\n
\r\ndb = new mysqli("localhost", USER, PW, NAME);\r\ndb->set_charset("utf8mb4")\r\n<\/pre>\n
\n","protected":false},"excerpt":{"rendered":"