{"id":479,"date":"2017-08-20T06:39:16","date_gmt":"2017-08-20T06:39:16","guid":{"rendered":"http:\/\/ta.onionmixer.net\/wordpress\/?p=479"},"modified":"2017-08-20T06:39:16","modified_gmt":"2017-08-20T06:39:16","slug":"mediawiki-%eb%a9%94%ec%9d%b8%ed%84%b0%eb%84%8c%ec%8a%a4-%ea%b8%b0%eb%a1%9d","status":"publish","type":"post","link":"http:\/\/ta.onionmixer.net\/wordpress\/?p=479","title":{"rendered":"mediawiki \uba54\uc778\ud130\ub10c\uc2a4 \uae30\ub85d"},"content":{"rendered":"<p>\uc774 \ub0b4\uc6a9\uc740 sqlite \ub85c \uc6b4\uc601\ub418\ub358 mediawiki \uc758 1.20(\uad6c\ud615\ubc84\uc804)\uc744 1.29 \ubc84\uc804\uc73c\ub85c \uc62c\ub9ac\uba74\uc11c \uc77c\uc5b4\ub09c \uc77c\uc5d0 \ub300\ud55c \uac04\ub2e8\ud55c \uba54\ubaa8\uc785\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ub0b4\uac00 \uc6d0\ub798 \uc4f0\ub358 wiki db \ub294 sqlite<\/li>\n<li>\ucd5c\uadfc\uc5d0 php \uc758 \ubc84\uc804\uc744 \uc62c\ub9bc\uc5d0 \ub530\ub77c mediawiki \uc758 \ubc84\uc804\uc744 \uc62c\ub824\uc57c\ud560 \ud544\uc694\uc131\uc774 \uc0dd\uacbc\ub2e4<\/li>\n<li>mediawiki \ub97c \uc62c\ub838\ub2e4. \uc77c\ub2e8 mediawiki \uc758 \ubc84\uc804\uc744 \uba3c\uc800 \uc62c\ub838\uc73c\uba70 mediawiki \uac00 \uae09\ud55c\ub300\ub85c \ub3d9\uc791\ud558\ub294\uac78 \ud655\uc778.<\/li>\n<li>\uba87\uac00\uc9c0 \uc790\uc798\ud55c \ubb38\uc81c\uac00 \uc0dd\uacbc\ub294\ub370.. \ub300\uac1c\ub294 \ud574\uacb0\uc774 \uac00\ub2a5\ud588\uc73c\ub098 sqlite \uc758 \uc131\ub2a5\ubb38\uc81c\ub85c \ud55c\uacc4\uc5d0 \ub2e4\ub2e4\ub974\uae30 \uc2dc\uc791\ud588\ub2e4. wiki \ud398\uc774\uc9c0\ub97c \uba87\ubc88\uc815\ub3c4 refresh \ud558\uba74 db \uc5d0\ub7ec\uac00 \ubc1c\uc0dd.<\/li>\n<li>\uadf8\uac78 \ud574\uacb0\ud558\uace0\uc790 \ud558\uc600\uc73c\ub098 \uadf8 \uacfc\uc815\uc5d0\uc11c sqlite db schema \uac00 \uaf2c\uc784..(\uc624\ub178)<\/li>\n<li>\uba87\uac00\uc9c0 \uc6d0\uc778\uc740 \uc788\uc5c8\uc73c\ub098 sqlite \ub97c mysql \ub85c \ubc14\uafb8\uae30\ub85c \uacb0\uc815. \uc774\uc5d0 upgrade \uac00 \ub05d\ub09c \uae30\uc874\uc758 mediawiki \ub294 mediawiki_sqlite \ub4f1\uc73c\ub85c \uc774\ub984\uc744 \ubcc0\uacbd\ud558\uace0 mediawiki \ub97c mysql \ubc84\uc804\uc73c\ub85c \ub2e4\uc2dc \uc2e0\uaddc\uc124\uce58<\/li>\n<li>mediawiki \uc758 \uae30\ub2a5\uc911 \ud558\ub098\uc778 dumpBackup.php \/ importDump.php \ub85c \ud574\uacb0\uc744 \ubcf4\ub824 \ud588\uc73c\ub098 \uc644\ubcbd\ud558\uac8c\ub294 \ucc98\ub9ac\uac00 \uc548\ub428. \ud398\uc774\uc9c0\uc758 image \uc815\ubcf4 \ubd80\ubd84\uc744 \uc81c\ub300\ub85c \uac00\uc838\uc624\uc9c0 \ubabb\ud568. \uadf8\ub9ac\uace0 importDump.php \ub294 wiki \ud398\uc774\uc9c0 \uc22b\uc790\uc5d0 \ube44\ub840\ud574\uc11c \uc2dc\uac04\uc774 \uaf64 \uac78\ub9ac\ub2c8 \ubc18\ub4dc\uc2dc \ucc38\uace0\ud560\uac83. 3000 \ud398\uc774\uc9c0 \uac00\ub7c9\uc758 wiki \ub97c Import \ud560 \ub54c \uac78\ub9ac\ub294 \uc2dc\uac04\uc740 \ub300\ub7b5 3\uc2dc\uac04&#8230;..(\ubb3c\ub860 \uc11c\ubc84\uac00 \uc880 \uad6c\ub9ac\uae30\ub294&#8230;-.-)<\/li>\n<li>sqlite \uc640 mysql \ubc84\uc804\uc758 \ud574\ub2f9 db table \uc758 schema \ub97c \ubd84\uc11d\ud558\uace0 \ubcc4 \uc774\uc0c1\uc774 \uc5c6\uaca0\ub2e4 \uc2f6\uc5b4\uc11c sqlite \uc5d0\uc11c \ud574\ub2f9\ub418\ub294 \ud14c\uc774\ube14\uc744 \ucd94\uc801\ud574\uc11c sql \ud615\ud0dc\ub85c dump \uc744 \ub5a0\ub0c4. \uc774\ub807\uac8c sqlite \uc5d0\uc11c dump \ub41c sql \uc740 \uc0c1\ub2e8 \ubd80\ubd84\uc5d0 \uc7a1\ub2e4\ud55c \ubd80\ubd84\uc774 \uc788\uc73c\ub2c8 \uadf8 \ubd80\ubd84\uc740 \uc190\uc73c\ub85c \uac77\uc5b4\ub0b4 \uc8fc\uc5b4\uc57c\ud568<\/li>\n<li>\ubb3c\ub860 dump \ub72c sql \uc744 mysql db \uc5d0 \ub123\uc74c. \ub450\uc904\uc815\ub3c4? \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud588\uc73c\ub098.. \uadf8\uc815\ub3c4\ub294 \uc190\uc73c\ub85c \uc7a1\uc744 \uc218 \uc788\uc74c<\/li>\n<li>\uc2e0\uaddc mediawiki \uc758 \uba54\uc778\ud398\uc774\uc9c0\ub294 importDump.php \ub85c \ubcf5\uad6c\uac00 \ub418\uc9c0 \uc54a\uc74c. \ub54c\ubb38\uc5d0 \uc774\uc804\uc758 old wiki \uc5d0\uc11c \uba54\uc778\ud398\uc774\uc9c0\ub294 \uc190\uc73c\ub85c \uc9c1\uc811 \uc62e\uaca8\uc8fc\ub294 \uc13c\uc2a4!<\/li>\n<li>\uba87\uac00\uc9c0 \ud15c\ud50c\ub9bf\uc744 \ube44\ub86f\ud574\uc11c \uc815\uc0c1 \ub3d9\uc791\ud560 \uc218 \uc788\ub3c4\ub85d mediawiki \uc758 \uc870\uc815\uc744 \ub9c8\ubb34\ub9ac<\/li>\n<li>\uae30\uc874\uc5d0 mediawiki \ub97c \uc62c\ub9ac\uba74\uc11c \ub3d9\uc791\uc774 \ub418\uc9c0 \uc54a\uc558\ub358 syntexhighlight_geshi \ud50c\ub7ec\uadf8\uc778\uae4c\uc9c0 \uc815\uc0c1\ub3d9\uc791\ud558\uac8c \uc791\uc5c5. \uc774 \ubd80\ubd84\uc740 \ud574\ub2f9 \ud50c\ub7ec\uadf8\uc778\uc758 pygmentize \ubd80\ubd84\uc744 \ucc38\uc870\ud560\uac83<\/li>\n<li>\uc791\uc5c5\uc774 \ub2e4 \ub05d\ub098\uba74 mediawki \uc758 index \ub97c \ub2e4\uc2dc \uc7a1\uc544\uc8fc\ub294 \uc77c\uc744 \uc78a\uc9c0 \ub9d0\uac83.<\/li>\n<li>mediawiki \uc758 mysql \ubc84\uc804 \uae30\ubcf8\uc124\uce58\uac00 \ub05d\ub0ac\uc744\ub54c mysql \uc744 \ubc31\uc5c5\ubc1b\ub294\uac78 \uc78a\uc9c0 \ub9c8\uc138\uc694. \uadf8\ub798\uc57c \uc791\uc5c5\uc744 \uc2e4\ud328\ud588\uc744 \ub54c \uc774\ud6c4 \ubcf5\uad6c\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc544\uc6b8\ub7ec \uc0ac\uc6a9\ud588\ub358 \uba85\ub839\uc5b4\uc911\uc5d0 \uc911\uc694\ud55c \ubd80\ubd84\uc744 \uba54\ubaa8\uc0bc\uc544 \ub0a8\uaca8\ub193\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>mysqldump -u\uc0ac\uc6a9\uc790\uc774\ub984 -p\ube44\ubc00\ubc88\ud638 mysqlDB\uc774\ub984 &gt; db_backup_default.sql<\/li>\n<li>nice -19 php maintenance\/importDump.php &#8211;report &#8211;uploads &lt; ~\/\ub364\ud504XML\ud30c\uc77c\uc774\ub984.xml<\/li>\n<li>sqlite3 sqlite3DB\uc774\ub984.sqlite &#8216;.dump image&#8217; &gt; dump_image_table_fromsqlite.sql<\/li>\n<li>php maintenance\/update.php &#8211;quick<\/li>\n<li>nice -19 php maintenance\/rebuildall.php<\/li>\n<li>php maintenance\/initSiteStats.php &#8211;update<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc774 \ub0b4\uc6a9\uc740 sqlite \ub85c \uc6b4\uc601\ub418\ub358 mediawiki \uc758 1.20(\uad6c\ud615\ubc84\uc804)\uc744 1.29 \ubc84\uc804\uc73c\ub85c \uc62c\ub9ac\uba74\uc11c \uc77c\uc5b4\ub09c \uc77c\uc5d0 \ub300\ud55c \uac04\ub2e8\ud55c \uba54\ubaa8\uc785\ub2c8\ub2e4. \ub0b4\uac00 \uc6d0\ub798 \uc4f0\ub358 wiki db \ub294 sqlite \ucd5c\uadfc\uc5d0 php \uc758 \ubc84\uc804\uc744 \uc62c\ub9bc\uc5d0 \ub530\ub77c mediawiki \uc758 \ubc84\uc804\uc744 \uc62c\ub824\uc57c\ud560 \ud544\uc694\uc131\uc774 \uc0dd\uacbc\ub2e4 mediawiki \ub97c \uc62c\ub838\ub2e4. \uc77c\ub2e8 mediawiki \uc758 \ubc84\uc804\uc744 \uba3c\uc800 \uc62c\ub838\uc73c\uba70 mediawiki \uac00 \uae09\ud55c\ub300\ub85c \ub3d9\uc791\ud558\ub294\uac78 \ud655\uc778. \uba87\uac00\uc9c0 \uc790\uc798\ud55c \ubb38\uc81c\uac00 \uc0dd\uacbc\ub294\ub370.. \ub300\uac1c\ub294 \ud574\uacb0\uc774 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75],"tags":[108,110,109],"_links":{"self":[{"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/479"}],"collection":[{"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=479"}],"version-history":[{"count":1,"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/479\/revisions"}],"predecessor-version":[{"id":480,"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/479\/revisions\/480"}],"wp:attachment":[{"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=479"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/ta.onionmixer.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}