Warning: Error while sending QUERY packet. PID=24842 in /home/uls/public_html/wordpress/wp-includes/class-wpdb.php on line 2357
{"id":94,"date":"2012-02-17T11:44:43","date_gmt":"2012-02-17T11:44:43","guid":{"rendered":"http:\/\/192.168.1.20\/wordpress\/freebsd\/2012\/02\/17\/movabletype_4\/"},"modified":"2015-01-25T00:49:37","modified_gmt":"2015-01-25T00:49:37","slug":"movabletype_4","status":"publish","type":"post","link":"http:\/\/uls.self.jp\/wordpress\/freebsd\/?p=94","title":{"rendered":"Movabletype\u3092\u5225\u30b5\u30fc\u30d0\u30fc\u306b\u79fb\u52d5\/\u30b3\u30d4\u30fc"},"content":{"rendered":"<p>Movable type\u306e\u6700\u65b0\u7248\u306f\u3001MT-5.x\u3060\u304c\u3001\u4eca\u3067\u30823.35\u3092\u4f7f\u3063\u3066\u3044\u308b\u3002<br \/>\n\u7406\u7531\u306f\u3001MT-3.x\u306e\u6642\u4ee3\u306b\u6563\u3005\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3092\u65bd\u3057\u3001Text\u306eFormatter\u306a\u3069\u3082\u3053\u306e\u30d6\u30ed\u30b0\u306e\u8a18\u4e8b\u306e\u3088\u3046\u306b\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u306e\u8a18\u8ff0\u306b\u90fd\u5408\u304c\u826f\u3044\u3088\u3046\u306b\u66f8\u304d\u76f4\u3057\u3066\u3001Plugin\u3068\u3057\u3066\u4f7f\u3063\u3066\u3044\u308b\u304b\u3089\u3067\u3042\u308b\u3002\u3055\u3089\u306b\u306f\u3001\u6570\u4eba\u306e\u53cb\u4eba\u304c\u30d6\u30ed\u30b0\u30da\u30fc\u30b8\u3092\u958b\u3044\u3066\u3044\u308b\u306e\u3067\u3001MMI\u304c\u5909\u308f\u308b\u3068\u6238\u60d1\u3046\u3053\u3068\u3092\u6050\u308c\u308b\u304b\u3089\u3067\u3042\u308b\u3002<br \/>\n\u3055\u3066\u3001\u81ea\u5b85\u5185\u3067\u904b\u7528\u3057\u3066\u3044\u308b\u30b5\u30fc\u30d0\u30fc\u304c\u58ca\u308c\u305f\u3053\u3068\u3092\u8003\u3048\u3001\u5225\u306e\u4e88\u5099\u30b5\u30fc\u30d0\u30fc\u3092\u7acb\u3061\u4e0a\u3052\u8272\u3005\u306a\u30b5\u30fc\u30d3\u30b9\u306e\u8a2d\u5b9a\u3092\u884c\u3063\u3066\u3044\u308b\u304c\u3001\u30d6\u30ed\u30b0\u3092\u79fb\u8a2d\u3059\u308b\u306e\u306b\u624b\u9593\u53d6\u3063\u305f\u306e\u3067\u3001\u4e0b\u8a18\u306b\u305d\u306e\u985b\u672b\u3092\u66f8\u3044\u3066\u304a\u304f\u3002<\/p>\n<h4>1. \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u306e\u30b3\u30d4\u30fc<\/h4>\n<blockquote><p>(1) mt.cgi\u306e\u5165\u3063\u3066\u3044\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u306a\u3089\u3073\u306b\u30d6\u30ed\u30b0\u306e\u516c\u958b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u3092rsync\u306a\u3069\u3092\u4f7f\u3063\u3066\u5168\u3066<br \/>\n\u4e88\u5099\u30b5\u30fc\u30d0\u30fc\u306b\u30b3\u30d4\u30fc\u3059\u308b\u3002<br \/>\n(2) CGIPath\u306e\u5909\u66f4<br \/>\nmt-config.cgi\u306b\u66f8\u304b\u308c\u3066\u3044\u308bCGIPath\u3092\u4e88\u5099\u30b5\u30fc\u30d0\u30fc\u306eURL\u306b\u5909\u66f4\u3059\u308b\u3002<\/p><\/blockquote>\n<pre>\u4f8b\uff1a\u3000CGIPath http:\/\/abc.myhome.jp  \u2192\u3000CGIPath http:\/\/xyz.myhome.jp<\/pre>\n<h4>2. \u5143\u306e\u30b5\u30fc\u30d0\u30fc\u3067\u30d6\u30ed\u30b0\u306eDB\u3092dump<\/h4>\n<pre># mysqldump --default-character-set=binary -u USER -pPASS BLOGDB &gt; abcblogdb<\/pre>\n<blockquote><p>USER, PASS, BLOGDB\u306f\u3001\u8a2d\u5b9a\u3057\u305f\u6b63\u3057\u3044\u5024\u3092\u5165\u308c\u308b\u3053\u3068\u3002<\/p>\n<li>\u4e88\u5099\u30b5\u30fc\u30d0\u30fc\u3067\u30ea\u30b9\u30c8\u30a2<\/li>\n<p>\u3000(1) \u5143\u306e\u30b5\u30fc\u30d0\u30fc\u3067dump\u3057\u305fDB\u30c7\u30fc\u30bf\u30fc\u3092ftp\u306a\u3069\u3067\u4e88\u5099\u30b5\u30fc\u30d0\u30fc\u306b\u30b3\u30d4\u30fc\u3059\u308b\u3002<br \/>\n\u3000(2) sed\u3092\u4f7f\u3063\u3066URL\u540d\u3092\u5909\u66f4<\/p>\n<li>10MB\u8fd1\u3044\u30c7\u30fc\u30bf\u30fc\u91cf\u3067\u3001\u6570\u5206\u8981\u3057\u305f\u3002<\/li>\n<\/blockquote>\n<pre># sed -e \"s\/abc.myhome.jp\/xyz.myhome.jp\/g\" abcblogdb &gt; xyzblogdb<\/pre>\n<p>(3) DB\u306e\u30ea\u30b9\u30c8\u30a2<\/p>\n<pre># mysql -u USER -pPASS BLOGDB &lt;  xyzbogdb<\/pre>\n<blockquote><p>ERROR 2006 (HY000) at line 66: MySQL server has gone away\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3002<br \/>\n66\u884c\u76ee\u3067\u30a8\u30e9\u30fc\u3068\u3044\u3046\u306e\u306766\u884c\u76ee\u3092\u898b\u308b\u3068\u3001<br \/>\nLOCK TABLES `mt_author` WRITE;\u3000\u3068\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\n\u3053\u3053\u3067\u3001LOCK TABLES\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u304c\u60aa\u3044\u306e\u304b\u3068\u601d\u3063\u3066\u3001UNLOCK TABLES\u306bsed\u3092\u4f7f\u3063\u3066\u66f8\u304d\u63db\u3048\u3066\u307f\u305f\u304c\u3001\u4eca\u5ea6\u306f\u5225\u306e\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3001\u69cb\u6587\u306e\u30a8\u30e9\u30fc\u306a\u306e\u3067\u30de\u30cb\u30e5\u30a2\u30eb\u3092\u3088\u304f\u8aad\u3081\u3068\u8a00\u3063\u3066\u304f\u308b\u3002<br \/>\n\u3053\u3053\u3067\u304a\u624b\u4e0a\u3052\u304b\u3068\u601d\u3063\u305f\u304c\u3001Net\u3067\u8272\u3005\u8abf\u3079\u305f\u3089\u3001mysql\u306e\u8ee2\u9001\u306e\u6700\u5927\u30d1\u30b1\u30c3\u30c8\u6570\u304c\u4e0d\u8db3\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u3063\u305f\u3002<br \/>\n\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u884c\u306b\u3001\u305f\u307e\u305f\u307eLOCK TABLES\u306e\u8a9e\u53e5\u304c\u3042\u3063\u305f\u306e\u3067\u3001\u3053\u308c\u304c\u539f\u56e0\u304b\u3068\u601d\u3063\u3066\u6df7\u4e71\u3057\u3066\u3057\u307e\u3063\u305f\u3002\u3068\u3082\u304b\u304f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bpacket\u6570\u3092\u4fee\u6b63\u3057\u305f\u3002<\/p><\/blockquote>\n<pre># vi \/etc\/my.cnf\n\u30fb\n[mysqld]\n\u30fb\nmax_allowed_packet = 1M\u3000\u2192\u3000<span style=\"color: #ff0000\">32M<\/span>\u306b\u4fee\u6b63\u3057\u305f<\/pre>\n<blockquote><p>\u3061\u306a\u307f\u306b\u3001[mysqldump]\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001max_allowed_packet = 16M\u3000\u3068\u306a\u3063\u3066\u3044\u305f\u3002<br \/>\nmysql\u3092\u518d\u30b9\u30bf\u30fc\u30c8<\/p><\/blockquote>\n<pre># \/usr\/local\/etc\/rc.d\/mysql-server restart<\/pre>\n<blockquote><p>\u3053\u3053\u3067\u3001\u518d\u5ea6DB\u306e\u30ea\u30b9\u30c8\u30a2<\/p><\/blockquote>\n<pre># mysql -u USER -pPASS BLOGDB &lt;  xyzbogdb<\/pre>\n<blockquote><p>\u4eca\u5ea6\u306f\u30a8\u30e9\u30fc\u306a\u304f\u7121\u4e8b\u7d42\u4e86\u3057\u305f\u3002<\/p><\/blockquote>\n<h4>3.\u30d6\u30ed\u30b0\u306e\u518d\u69cb\u7bc9<\/h4>\n<blockquote><p>mt.cgi\u3092\u30d6\u30e9\u30a6\u30b6\u3067\u958b\u3044\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3002\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5143\u306e\u30b5\u30fc\u30d0\u30fc\u3067\u7528\u3044\u3066\u3044\u305f\u306e\u3092\u4f7f\u3044\u30ed\u30b0\u30a4\u30f3\u3057\u3001\u8907\u6570\u306e\u30d6\u30ed\u30b0\u3092\u9806\u6b21\u958b\u3044\u3066\u3001\u516c\u958b\u30d1\u30b9\u304c\u4e88\u5099\u30b5\u30fc\u30d0\u306b\u5bfe\u5fdc\u3057\u305f\u3082\u306e\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3001\u30b5\u30a4\u30c8\u306e\u518d\u69cb\u7bc9\u3092\u884c\u3046\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/uls.self.jp\/bsdimg\/blogurl.jpg\" alt=\"blogurl.jpg\" width=\"647\" height=\"475\" \/><br \/>\n\u3053\u308c\u3067\u3001\u7121\u4e8b\u7d42\u4e86\u3067\u3042\u308b\u3002\u66f8\u304f\u3068\u8907\u96d1\u306e\u3088\u3046\u3060\u304c\u3001\u5206\u304b\u3063\u3066\u3057\u307e\u3046\u3068\u6ca2\u5c71\u306e\u30da\u30fc\u30b8\u3092\u6709\u3059\u308b\u30d6\u30ed\u30b0\u3067\u3042\u3063\u3066\u3082\u77ed\u6642\u9593\u3067\u5f15\u8d8a\u3057\u304c\u3067\u304d\u308b\u3002<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Movable type\u306e\u6700\u65b0\u7248\u306f\u3001MT-5.x\u3060\u304c\u3001\u4eca\u3067\u30823.35\u3092\u4f7f\u3063\u3066\u3044\u308b\u3002 \u7406\u7531\u306f\u3001MT-3.x\u306e\u6642\u4ee3\u306b\u6563\u3005\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3092\u65bd\u3057\u3001Text\u306eFormatter\u306a\u3069\u3082\u3053\u306e\u30d6\u30ed\u30b0\u306e\u8a18\u4e8b\u306e\u3088\u3046\u306b\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u306e\u8a18\u8ff0\u306b\u90fd\u5408 &hellip; <a href=\"http:\/\/uls.self.jp\/wordpress\/freebsd\/?p=94\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-movabletype","wpautop"],"_links":{"self":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94"}],"version-history":[{"count":7,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":274,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions\/274"}],"wp:attachment":[{"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/uls.self.jp\/wordpress\/freebsd\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}