{"id":235,"date":"2017-04-19T16:53:12","date_gmt":"2017-04-19T07:53:12","guid":{"rendered":"http:\/\/medicalfields.jp\/blog\/?p=235"},"modified":"2018-12-13T21:32:09","modified_gmt":"2018-12-13T12:32:09","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e6%99%82%e3%81%aberror-2006-hy000-mysql-server-has-gone-away","status":"publish","type":"post","link":"https:\/\/medicalfields.jp\/blog\/sql\/%e3%83%87%e3%83%bc%e3%82%bf%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e6%99%82%e3%81%aberror-2006-hy000-mysql-server-has-gone-away\/","title":{"rendered":"\u30c7\u30fc\u30bf\u30a4\u30f3\u30dd\u30fc\u30c8\u6642\u306bERROR 2006 (HY000): MySQL server has gone away"},"content":{"rendered":"<p>c:\\xampp\\mysql\\bin\\mysqldump.exe -hHOST -uUSER -pPW &#8211;max_allowed_packet=512M \u8ee2\u9001\u5143DB | c:\\xampp\\mysql\\bin\\mysql.exe -hHOST -uUSER -pPW &#8211;max_allowed_packet=512M \u8ee2\u9001\u5148DB<\/p>\n<p>\u3067\u63a5\u7d9a\u5148\u306eDB\u306b\u305d\u306e\u307e\u307eDB\u3092\u30b3\u30d4\u30fc\u51fa\u6765\u308b\u3068\u601d\u3063\u305f\u3093\u3060\u3051\u3069<br \/>\nERROR 2006 (HY000): MySQL server has gone away<br \/>\n\u3063\u3066\u3067\u308b<\/p>\n<p>\u63a5\u7d9a\u5148\u306emysql\u304c\u843d\u3061\u3066\u305d\u3046<\/p>\n<p>max_allowed_packet\u6307\u5b9a\u3057\u3066\u3066\u3082\u51fa\u308b\u304b\u3089\u4ed5\u65b9\u306a\u3044\u304b\u3089\u63a5\u7d9a\u5148\u306eDB\u306emax_allowed_packet\u3092\u4e0a\u3052\u308b<\/p>\n<p>vi \/etc\/my.cnf<\/p>\n<p>[mysqld]<br \/>\nmax_allowed_packet = 1000M<\/p>\n<p>\u4e00\u756a\u4e0b\u306b\u8ffd\u52a0\u3059\u308b<\/p>\n<p>\u52d5\u304f\u3068\u3044\u3044\u306d\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>c:\\xampp\\mysql\\bin\\mysqldump.exe -hHOST -uUSER -pPW &#8211;max_allowed_packet=512M \u8ee2\u9001\u5143DB | c:\\xampp\\mysql\\bin\\ &hellip; <a href=\"https:\/\/medicalfields.jp\/blog\/sql\/%e3%83%87%e3%83%bc%e3%82%bf%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e6%99%82%e3%81%aberror-2006-hy000-mysql-server-has-gone-away\/\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u30c7\u30fc\u30bf\u30a4\u30f3\u30dd\u30fc\u30c8\u6642\u306bERROR 2006 (HY000): MySQL server has gone away<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[9],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6kJO0-3N","_links":{"self":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/235"}],"collection":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/comments?post=235"}],"version-history":[{"count":4,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/235\/revisions\/239"}],"wp:attachment":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/media?parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/categories?post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/tags?post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}