Help:Guide to setting up interwiki linking/ko

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search
Blue Glass Arrow.svg MediaWiki logo.png
This page should be moved to MediaWiki.org.
Please do not move the page by hand. It will be imported by a MediaWiki.org administrator with the full edit history. In the meantime, you may continue to edit the page as normal.


Links to other help pages[edit]

Help contents
Meta · Wikinews · Wikipedia · Wikiquote · Wiktionary · Commons: · Wikidata · MediaWiki · Wikibooks · Wikisource · MediaWiki: Manual · Google
Versions of this help page (for other languages see further)
What links here on Meta or from Meta · Wikipedia · MediaWiki
Reading
Go · Search · Stop words · Namespace · Page name · Section · Backlinks · Redirect · Category · Image page · Special pages · Printable version
Tracking changes
Recent changes (enhanced) | Related changes · Watching pages · Diff · Page history · Edit summary · User contributions · Minor edit · Patrolled edit
Logging in and preferences
Logging in · Preferences · User style
Editing
Starting a new page · Advanced editing · Editing FAQ · Edit toolbar · Export · Import · Shortcuts · Edit conflict · Page size
Referencing
Links · URL · Piped links · Interwiki linking · Footnotes
Style and formatting
Wikitext examples · CSS · Reference card · HTML in wikitext · Formula · List · Table · Sorting · Colors · Images and file uploads
Fixing mistakes
Show preview · Testing · Reverting edits
Advanced functioning
Expansion · Template · Advanced templates · Parser function · Parameter default · Variable · System message · Substitution · Array · Calculation · Embed page
Others
Special characters · Renaming (moving) a page · Preparing a page for translation · Talk page · Signatures · Sandbox · Legal issues for editors
언어: English · français · 한국어


미디어위키에 인터위키 설정하는 방법[edit]

예제는 ko:user:멀뚱이가 직접 실행한 것이다.

mysql 시작하기[edit]

mysql -u <mysql 관리자 계정> -p

그리고 나서 암호를 입력한다.

mysql> USE <미디어위키 데이타베이스 이름>

예제:

[jimy@dhcp-323-95323 ~]$ su -
Password:
[root@dhcp-323-95323 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 45 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
mysql> use wdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

인터위키 테이블 보기[edit]

여기서 interwiki는 혹시 테이블 prefix를 설정한 경우에는 yourprefix_interwiki를 쓰라는 의미이다.

interwiki<tab><tab> 탭키를 두번 누른다.

mysql> interwiki (엔터키 치지말고 탭키를 연속 두 번 누르기)
interwiki            interwiki.iw_prefix
interwiki.iw_local   interwiki.iw_url
mysql> interwiki 

예제:

Database changed
mysql> mw_interwiki (엔터키 치지말고 탭키를 연속 두 번 누르기)
mw_interwiki            mw_interwiki.iw_prefix  mw_interwiki.iw_url
mw_interwiki.iw_local   mw_interwiki.iw_trans
mysql> mw_interwiki

주된 테이블은 'interwiki'이다.

이제 이 테이블의 내용들을 보자:

SELECT COUNT(*) FROM interwiki;

무엇이 있나 보자:

SELECT * FROM interwiki;

예제:

mysql> SELECT COUNT(*) FROM mw_interwiki;
+----------+
| COUNT(*) |
+----------+
|      179 |
+----------+
1 row in set (0.09 sec)

mysql> SELECT * FROM mw_interwiki;
+---------------------+-----------------------------------------------------------------------------------+----------+----------+
| iw_prefix           | iw_url                           | iw_local | iw_trans |
+---------------------+-----------------------------------------------------------------------------------+----------+----------+
| abbenormal          | http://www.ourpla.net/cgi-bin/pikie.cgi?$1                           |        0 |        0 |
| acadwiki            | http://xarch.tu-graz.ac.at/autocad/wiki/$1                           |        0 |        0 |
| acronym             | http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=$1                 |        0 |        0 |
| advogato            | http://www.advogato.org/$1                           |        0 |        0 |
| aiwiki              | http://www.ifi.unizh.ch/ailab/aiwiki/aiw.cgi?$1                           |        0 |        0 |
| alife               | http://news.alife.org/wiki/index.php?$1                           |        0 |        0 |
| annotation          | http://bayle.stanford.edu/crit/nph-med.cgi/$1                           |        0 |        0 |
| annotationwiki      | http://www.seedwiki.com/page.cfm?wikiid=368&doc=$1                           |        0 |        0 |
| arxiv               | http://www.arxiv.org/abs/$1                           |        0 |        0 |
| aspienetwiki        | http://aspie.mela.de/Wiki/index.php?title=$1                           |        0 |        0 |
| bemi                | http://bemi.free.fr/vikio/index.php?$1                           |        0 |        0 |
| benefitswiki        | http://www.benefitslink.com/cgi-bin/wiki.cgi?$1                           |        0 |        0 |
| brasilwiki          | http://rio.ifi.unizh.ch/brasilienwiki/index.php/$1                           |        0 |        0 |
| bridgeswiki         | http://c2.com/w2/bridges/$1                           |        0 |        0 |
| c2find              | http://c2.com/cgi/wiki?FindPage&value=$1                           |        0 |        0 |
| cache               | http://www.google.com/search?q=cache:$1                           |        0 |        0 |
| ciscavate           | http://ciscavate.org/index.php/$1                           |        0 |        0 |
| cliki               | http://ww.telent.net/cliki/$1                           |        0 |        0 |
| cmwiki              | http://www.ourpla.net/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| codersbase          | http://www.codersbase.com/$1                           |        0 |        0 |
| commons             | http://commons.wikimedia.org/wiki/$1                           |        0 |        0 |
| consciousness       | http://teadvus.inspiral.org/                           |        0 |        0 |
| corpknowpedia       | http://corpknowpedia.org/wiki/index.php/$1                           |        0 |        0 |
| creationmatters     | http://www.ourpla.net/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| dejanews            | http://www.deja.com/=dnc/getdoc.xp?AN=$1                           |        0 |        0 |
| demokraatia         | http://wiki.demokraatia.ee/                           |        0 |        0 |
| dictionary          | http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1            |        0 |        0 |
| disinfopedia        | http://www.disinfopedia.org/wiki.phtml?title=$1                           |        0 |        0 |
| diveintoosx         | http://diveintoosx.org/$1                           |        0 |        0 |
| docbook             | http://docbook.org/wiki/moin.cgi/$1                           |        0 |        0 |
| dolphinwiki         | http://www.object-arts.com/wiki/html/Dolphin/$1                           |        0 |        0 |
| drumcorpswiki       | http://www.drumcorpswiki.com/index.php/$1                           |        0 |        0 |
| dwjwiki             | http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1                           |        0 |        0 |
| echei               | http://www.ikso.net/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| ecxei               | http://www.ikso.net/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| efnetceewiki        | http://purl.net/wiki/c/$1                           |        0 |        0 |
| efnetcppwiki        | http://purl.net/wiki/cpp/$1                           |        0 |        0 |
| efnetpythonwiki     | http://purl.net/wiki/python/$1                           |        0 |        0 |
| efnetxmlwiki        | http://purl.net/wiki/xml/$1                           |        0 |        0 |
| elibre              | http://enciclopedia.us.es/index.php/$1                           |        0 |        0 |
| eljwiki             | http://elj.sourceforge.net/phpwiki/index.php/$1                           |        0 |        0 |
| emacswiki           | http://www.emacswiki.org/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| eokulturcentro      | http://esperanto.toulouse.free.fr/wakka.php?wiki=$1                           |        0 |        0 |
| evowiki             | http://www.evowiki.org/index.php/$1                           |        0 |        0 |
| eĉei               | http://www.ikso.net/cgi-bin/wiki.pl?$1                          |        0 |        0 |
| finalempire         | http://final-empire.sourceforge.net/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| firstwiki           | http://firstwiki.org/index.php/$1                           |        0 |        0 |
| foldoc              | http://www.foldoc.org/foldoc/foldoc.cgi?$1                           |        0 |        0 |
| foxwiki             | http://fox.wikis.com/wc.dll?Wiki~$1                           |        0 |        0 |
| fr.be               | http://fr.wikinations.be/$1                           |        0 |        0 |
| fr.ca               | http://fr.ca.wikinations.org/$1                           |        0 |        0 |
| fr.fr               | http://fr.fr.wikinations.org/$1                           |        0 |        0 |
| fr.org              | http://fr.wikinations.org/$1                           |        0 |        0 |
| freebsdman          | http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1                           |        0 |        0 |
| gamewiki            | http://gamewiki.org/wiki/index.php/$1                           |        0 |        0 |
| gej                 | http://www.esperanto.de/cgi-bin/aktivikio/wiki.pl?$1                           |        0 |        0 |
| gentoo-wiki         | http://gentoo-wiki.com/$1                           |        0 |        0 |
| globalvoices        | http://cyber.law.harvard.edu/dyn/globalvoices/wiki/$1                           |        0 |        0 |
| gmailwiki           | http://www.gmailwiki.com/index.php/$1                           |        0 |        0 |
| google              | http://www.google.com/search?q=$1                           |        0 |        0 |
| googlegroups        | http://groups.google.com/groups?q=$1                           |        0 |        0 |
| gotamac             | http://www.got-a-mac.org/$1                           |        0 |        0 |
| greencheese         | http://www.greencheese.org/$1                           |        0 |        0 |
| hammondwiki         | http://www.dairiki.org/HammondWiki/index.php3?$1                           |        0 |        0 |
| haribeau            | http://wiki.haribeau.de/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| herzkinderwiki      | http://www.herzkinderinfo.de/Mediawiki/index.php/$1                           |        0 |        0 |
| hewikisource        | http://he.wikisource.org/wiki/$1                           |        1 |        0 |
| hrwiki              | http://www.hrwiki.org/index.php/$1                           |        0 |        0 |
| iawiki              | http://www.IAwiki.net/$1                           |        0 |        0 |
| imdb                | http://us.imdb.com/Title?$1                           |        0 |        0 |
| infosecpedia        | http://www.infosecpedia.org/pedia/index.php/$1                           |        0 |        0 |
| jargonfile          | http://sunir.org/apps/meta.pl?wiki=JargonFile&redirect=$1                         |        0 |        0 |
| jefo                | http://www.esperanto-jeunes.org/vikio/index.php?$1                           |        0 |        0 |
| jiniwiki            | http://www.cdegroot.com/cgi-bin/jini?$1                           |        0 |        0 |
| jspwiki             | http://www.ecyrd.com/JSPWiki/Wiki.jsp?page=$1                           |        0 |        0 |
| kerimwiki           | http://wiki.oxus.net/$1                           |        0 |        0 |
| kmwiki              | http://www.voght.com/cgi-bin/pywiki?$1                           |        0 |        0 |
| knowhow             | http://www2.iro.umontreal.ca/~paquetse/cgi-bin/wiki.cgi?$1                        |        0 |        0 |
| ko                  | http://ko.wikipedia.org/wiki/$1                           |        1 |        0 |
| lanifexwiki         | http://opt.lanifex.com/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| lasvegaswiki        | http://wiki.gmnow.com/index.php/$1                           |        0 |        0 |
| linuxwiki           | http://www.linuxwiki.de/$1                           |        0 |        0 |
| lojban              | http://www.lojban.org/tiki/tiki-index.php?page=$1                           |        0 |        0 |
| lqwiki              | http://wiki.linuxquestions.org/wiki/$1                           |        0 |        0 |
| lugkr               | http://lug-kr.sourceforge.net/cgi-bin/lugwiki.pl?$1                           |        0 |        0 |
| lutherwiki          | http://www.lutheranarchives.com/mw/index.php/$1                           |        0 |        0 |
| m                   | http://meta.wikipedia.org/wiki/$1                           |        1 |        0 |
| mathsongswiki       | http://SeedWiki.com/page.cfm?wikiid=237&doc=$1                           |        0 |        0 |
| mbtest              | http://www.usemod.com/cgi-bin/mbtest.pl?$1                           |        0 |        0 |
| meatball            | http://www.usemod.com/cgi-bin/mb.pl?$1                           |        0 |        0 |
| mediazilla          | http://bugzilla.wikipedia.org/$1                           |        1 |        0 |
| memoryalpha         | http://www.memory-alpha.org/en/index.php/$1                           |        0 |        0 |
| meta                | http://meta.wikipedia.org/wiki/$1                           |        1 |        0 |
| metaweb             | http://www.metaweb.com/wiki/wiki.phtml?title=$1                           |        0 |        0 |
| metawiki            | http://sunir.org/apps/meta.pl?$1                           |        0 |        0 |
| metawikipedia       | http://meta.wikimedia.org/wiki/$1                           |        0 |        0 |
| moinmoin            | http://purl.net/wiki/moin/$1                           |        0 |        0 |
| mozillawiki         | http://wiki.mozilla.org/index.php/$1                           |        0 |        0 |
| muweb               | http://www.dunstable.com/scripts/MuWebWeb?$1                           |        0 |        0 |
| netvillage          | http://www.netbros.com/?$1                           |        0 |        0 |
| oeis                | http://www.research.att.com/cgi-bin/access.cgi/as/njas/sequences/eisA.cgi?Anum=$1 |        0 |        0 |
| openfacts           | http://openfacts.berlios.de/index.phtml?title=$1                           |        0 |        0 |
| openwiki            | http://openwiki.com/?$1                           |        0 |        0 |
| opera7wiki          | http://nontroppo.org/wiki/$1                           |        0 |        0 |
| orgpatterns         | http://www.bell-labs.com/cgi-user/OrgPatterns/OrgPatterns?$1                      |        0 |        0 |
| osi reference model | http://wiki.tigma.ee/                           |        0 |        0 |
| pangalacticorg      | http://www.pangalactic.org/Wiki/$1                           |        0 |        0 |
| patwiki             | http://gauss.ffii.org/$1                           |        0 |        0 |
| personaltelco       | http://www.personaltelco.net/index.cgi/$1                           |        0 |        0 |
| phpwiki             | http://phpwiki.sourceforge.net/phpwiki/index.php?$1                           |        0 |        0 |
| pikie               | http://pikie.darktech.org/cgi/pikie?$1                           |        0 |        0 |
| pmeg                | http://www.bertilow.com/pmeg/$1.php                           |        0 |        0 |
| ppr                 | http://c2.com/cgi/wiki?$1                           |        0 |        0 |
| purlnet             | http://purl.oclc.org/NET/$1                           |        0 |        0 |
| pythoninfo          | http://www.python.org/cgi-bin/moinmoin/$1                           |        0 |        0 |
| pythonwiki          | http://www.pythonwiki.de/$1                           |        0 |        0 |
| pywiki              | http://www.voght.com/cgi-bin/pywiki?$1                           |        0 |        0 |
| raec                | http://www.raec.clacso.edu.ar:8080/raec/Members/raecpedia/$1                      |        0 |        0 |
| revo                | http://purl.org/NET/voko/revo/art/$1.html                           |        0 |        0 |
| rfc                 | http://www.rfc-editor.org/rfc/rfc$1.txt                           |        0 |        0 |
| s23wiki             | http://is-root.de/wiki/index.php/$1                           |        0 |        0 |
| scoutpedia          | http://www.scoutpedia.info/index.php/$1                           |        0 |        0 |
| seapig              | http://www.seapig.org/$1                           |        0 |        0 |
| seattlewiki         | http://seattlewiki.org/wiki/$1                           |        0 |        0 |
| seattlewireless     | http://seattlewireless.net/?$1                           |        0 |        0 |
| seeds               | http://www.IslandSeeds.org/wiki/$1                           |        0 |        0 |
| senseislibrary      | http://senseis.xmp.net/?$1                           |        0 |        0 |
| shakti              | http://cgi.algonet.se/htbin/cgiwrap/pgd/ShaktiWiki/$1                           |        0 |        0 |
| slashdot            | http://slashdot.org/article.pl?sid=$1                           |        0 |        0 |
| smikipedia          | http://www.smikipedia.org/$1                           |        0 |        0 |
| sockwiki            | http://wiki.socklabs.com/$1                           |        0 |        0 |
| sourceforge         | http://sourceforge.net/$1                           |        0 |        0 |
| squeak              | http://minnow.cc.gatech.edu/squeak/$1                           |        0 |        0 |
| strikiwiki          | http://ch.twi.tudelft.nl/~mostert/striki/teststriki.pl?$1                         |        0 |        0 |
| susning             | http://www.susning.nu/$1                           |        0 |        0 |
| svgwiki             | http://www.protocol7.com/svg-wiki/default.asp?$1                           |        0 |        0 |
| tavi                | http://tavi.sourceforge.net/$1                           |        0 |        0 |
| tejo                | http://www.tejo.org/vikio/$1                           |        0 |        0 |
| terrorwiki          | http://www.liberalsagainstterrorism.com/wiki/index.php/$1                         |        0 |        0 |
| theopedia           | http://www.theopedia.com/$1                           |        0 |        0 |
| tmbw                | http://www.tmbw.net/wiki/index.php/$1                           |        0 |        0 |
| tmnet               | http://www.technomanifestos.net/?$1                           |        0 |        0 |
| tmwiki              | http://www.EasyTopicMaps.com/?page=$1                           |        0 |        0 |
| turismo             | http://www.tejo.org/turismo/$1                           |        0 |        0 |
| twiki               | http://twiki.org/cgi-bin/view/$1                           |        0 |        0 |
| twistedwiki         | http://purl.net/wiki/twisted/$1                           |        0 |        0 |
| uea                 | http://www.tejo.org/uea/$1                           |        0 |        0 |
| unreal              | http://wiki.beyondunreal.com/wiki/$1                           |        0 |        0 |
| ursine              | http://ursine.ca/$1                           |        0 |        0 |
| usej                | http://www.tejo.org/usej/$1                           |        0 |        0 |
| usemod              | http://www.usemod.com/cgi-bin/wiki.pl?$1                           |        0 |        0 |
| visualworks         | http://wiki.cs.uiuc.edu/VisualWorks/$1                           |        0 |        0 |
| w                   | http://www.wikipedia.org/wiki/$1                           |        1 |        0 |
| warpedview          | http://www.warpedview.com/index.php/$1                           |        0 |        0 |
| webdevwikinl        | http://www.promo-it.nl/WebDevWiki/index.php?page=$1                           |        0 |        0 |
| webisodes           | http://www.webisodes.org/$1                           |        0 |        0 |
| webseitzwiki        | http://webseitz.fluxent.com/wiki/$1                           |        0 |        0 |
| why                 | http://clublet.com/c/c/why?$1                           |        0 |        0 |
| wiki                | http://c2.com/cgi/wiki?$1                           |        0 |        0 |
| wikia               | http://www.wikia.com/wiki/index.php/$1                           |        0 |        0 |
| wikibooks           | http://en.wikibooks.org/wiki/$1                           |        1 |        0 |
| wikicities          | http://www.wikicities.com/index.php/$1                           |        0 |        0 |
| wikif1              | http://www.wikif1.org/$1                           |        0 |        0 |
| wikimedia           | http://wikimediafoundation.org/wiki/$1                           |        0 |        0 |
| wikinews            | http://en.wikinews.org/wiki/$1                           |        0 |        0 |
| wikinfo             | http://www.wikinfo.org/wiki.php?title=$1                           |        0 |        0 |
| wikiquote           | http://en.wikiquote.org/wiki/$1                           |        1 |        0 |
| wikisource          | http://sources.wikipedia.org/wiki/$1                           |        1 |        0 |
| wikispecies         | http://species.wikipedia.org/wiki/$1                           |        1 |        0 |
| wikitravel          | http://wikitravel.org/en/$1                           |        0 |        0 |
| wikiworld           | http://WikiWorld.com/wiki/index.php/$1                           |        0 |        0 |
| wikt                | http://en.wiktionary.org/wiki/$1                           |        1 |        0 |
| wiktionary          | http://en.wiktionary.org/wiki/$1                           |        1 |        0 |
| wlug                | http://www.wlug.org.nz/$1                           |        0 |        0 |
| wlwiki              | http://winslowslair.supremepixels.net/wiki/index.php/$1                           |        0 |        0 |
| ypsieyeball         | http://sknkwrks.dyndns.org:1957/writewiki/wiki.pl?$1                           |        0 |        0 |
| zu                  | http://zu.wikipedia.org/wiki/$1                           |        1 |        0 |
| zwiki               | http://www.zwiki.org/$1                           |        0 |        0 |
| zzz wiki            | http://wiki.zzz.ee/                           |        0 |        0 |
+---------------------+-----------------------------------------------------------------------------------+----------+----------+
179 rows in set (0.05 sec)
mysql>


SQL 테이블 내용에 대해 보다 자세한 것은 다음을 참조: http://dev.mysql.com/doc/refman/5.1/en/retrieving-data.html

인터위키 테이블 편집하기[edit]

나만의 인터위키 추가하기[edit]

매우 간단하다. 그냥 통째로 복사해다가 붙여넣기 한다.

가령, bugzilla-interwiki.sql 파일에 아래와 같은 내용이 들어있다.

REPLACE INTO interwiki (iw_prefix,iw_url,iw_local) VALUES
('kdebug','http://bugs.kde.org/show_bug.cgi?id=$1',0),
('mozbug','http://bugzilla.mozilla.org/show_bug.cgi?$1',0),
('gentoobug','http://bugs.gentoo.org/show_bug.cgi?$1',0);

그러면 위 내용을 그대로 블럭으로 잡아 복사한다.

그리고 나서

mysql>

이 상태에서 마우스 오른쪽 버튼을 누르고, 붙여넣기 한다. 그럼 원하는 인터위키가 추가된다.

예제: 위의 interwiki를 mw_interwiki 고쳤다는 것만 주의하면 된다.

mysql> REPLACE INTO mw_interwiki (iw_prefix,iw_url,iw_local) VALUES
    -> ('kdebug','http://bugs.kde.org/show_bug.cgi?id=$1',0),
    -> ('mozbug','http://bugzilla.mozilla.org/show_bug.cgi?$1',0),
    -> ('gentoobug','http://bugs.gentoo.org/show_bug.cgi?$1',0);
Query OK, 3 rows affected (0.28 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql>

아래와 같은 방법도 있다는데, 어렵다. 비추천이다.

mysql -u <username> -p <nameofyourdatabase> < <filename.sql>

mysql -u wikiuser -p wikidb < bugzilla-interwiki.sql

This does not report success when it works. If you want to double check, you have to check the interwiki table.

위키백과의 인터위키 목록을 사용하기[edit]

미디어위키 디렉토리에 보면, maintanance/wikipedia-interwiki.sql 파일이 있는데, 여기에 위키백과가 현재 사용하고 있는 인터위키 목록이 있다.

대략 일부만을 보면 다음과 같은 내용들이 있다:

REPLACE INTO interwiki (iw_prefix,iw_url,iw_local) VALUES
('w','http://www.wikipedia.org/wiki/$1',1),
('m','http://meta.wikipedia.org/wiki/$1',1),
('meta','http://meta.wikipedia.org/wiki/$1',1),
('zu','http://zu.wikipedia.org/wiki/$1',1);

뭐, 이것도 역시 위에서 말한 방법으로 그냥 복사해서 붙여넣으면 자동으로 다 실행된다.

그러나 더 간단한 방법을 소개한다.

mysql> \. /var/www/localhost/mediawiki-1.3.0/maintenance/wikipedia-interwiki.sql
Query OK, 155 rows affected (0.24 sec)
Records: 155  Duplicates: 0  Warnings: 0

mysql>  

예제:

mysql> \. /var/www/html/homewiki/maintenance/wikipedia-interwiki.sql
Query OK, 155 rows affected (0.24 sec)
Records: 155  Duplicates: 0  Warnings: 0

mysql>  

그러나, 그 파일 내용안에interwiki 앞에 프리픽스를 달아서 고쳐준 다음에 저 명령을 실행해야 한다.

wikipedia-interwiki.sql의 내용은 아래와 같다. 그거 맨 위에 interwiki만 앞에 접두어 제대로 달아주면 된다.

예를들어, ko:user:멀뚱이의 프리픽스는 위에서 본 바와 같이 mw_이다. 따라서

REPLACE INTO /*$wgDBprefix*/interwiki (iw_prefix,iw_url,iw_local) VALUES

이것을

 
REPLACE INTO /*$wgDBprefix*/mw_interwiki (iw_prefix,iw_url,iw_local) VALUES

이것으로 고쳐주면 된다. mw_ 라는 프리픽스만 추가해 주었다.

wikipedia-interwiki.sql의 내용:

-- For convenience, here are the *in-project* interwiki prefixes
-- for Wikipedia.

REPLACE INTO /*$wgDBprefix*/interwiki (iw_prefix,iw_url,iw_local) VALUES
('q','http://en.wikiquote.org/wiki/$1',1),
('b','http://en.wikibooks.org/wiki/$1',1),
('n','http://en.wikinews.org/wiki/$1',1),
('aa','http://aa.wikipedia.org/wiki/$1',1),
('ab','http://ab.wikipedia.org/wiki/$1',1),
('af','http://af.wikipedia.org/wiki/$1',1),
('ak','http://ak.wikipedia.org/wiki/$1',1),
('als','http://als.wikipedia.org/wiki/$1',1),
('am','http://am.wikipedia.org/wiki/$1',1),
('an','http://an.wikipedia.org/wiki/$1',1),
('ang','http://ang.wikipedia.org/wiki/$1',1),
('ar','http://ar.wikipedia.org/wiki/$1',1),
('arc','http://arc.wikipedia.org/wiki/$1',1),
('as','http://as.wikipedia.org/wiki/$1',1),
('ast','http://ast.wikipedia.org/wiki/$1',1),
('av','http://av.wikipedia.org/wiki/$1',1),
('ay','http://ay.wikipedia.org/wiki/$1',1),

뭐, 간단한 편집기로 위의 한 줄에 interwiki 만 mw_interwiki로 고쳐주고서, 그냥 통째로 복사해서

mysql> 여기서 마우스 오른쪽 클릭, 붙여넣기 해버리면 끝난다.

인터위키 누르면 새로운 창에서 열리게 하는 방법[edit]

무슨 말인지 몰라서 번역 안했다.

  1. Edit the Interwiki-table, the interwiki-link
  2. Add
" TARGET="_blank

with the quotes just like that at the end of the interwiki-link.

It should look like this:

http://de.wikipedia.org/wiki/$1" TARGET="_blank

see also: Opening external links in a new window

mysql 사용법의 추가 도움말[edit]

Mysql Help

위에 설명한 방법보다 phpMyAdmin 를 사용하기를 더 권장한다[edit]

영어판에는 그렇게 써놨는데, phpMyAdmin을 설치하는 거 의외로 까다롭다. 그러나 일단 phpMyAdmin가 설치되었다면 더 간단하다고 설명하고 있다. 번역 안했다.

http://www.stanton-finley.net/fedora_core_5_installation_notes.html#phpMyAdmin

ko:user:멀뚱이는 페도라 코어 5를 쓰는데, 여기에 phpMyAdmin을 설치하는 법 굉장히 쉽게 써 있다. 그대로 복사해다가 붙여넣기만 하면 된다. 아파치 웹서버네 기타 필요한 것도 매우 쉽게 설명해 놓았다.

If your server uses the software phpMyAdmin, you can simply select the database that uses the wiki (remember that your actual wikidb and wikiuser name were specified by you, and are stored in LocalSettings.php ), then select the table "interwiki" from the sidebar. To use the graphical interface, just select "browse" at the top and then you can opt to "insert new row" (at the bottom of the table) following the pattern established for the other items ("$1" is what will be replaced with whatever follows the interwiki prefix in your code; it will usually be at the end of the URL for the site for which you want to make a shortcut). Then click go or opt to insert another record until you are done.