How to export all pages from mediawiki into individual page files?

Question

Related to How to export text from all pages of a MediaWiki?, but I want the output be individual text files named using the page title.

SELECT page_title, page_touched, old_text
FROM revision,page,text
WHERE revision.rev_id=page.page_latest
AND text.old_id=revision.rev_text_id;

works to dump it into stdout and all pages in one go.

How to split them and dump into individual files?

SOLVED

First dump into one single file:

SELECT page_title, page_touched, old_text
FROM revision,page,text 
WHERE revision.rev_id=page.page_latest AND text.old_id=revision.rev_text_id AND page_namespace!='6' AND page_namespace!='8' AND  page_namespace!='12'
INTO OUTFILE '/tmp/wikipages.csv' 
FIELDS TERMINATED BY '\n' 
ESCAPED BY ''
LINES TERMINATED BY '\n@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n';

Then split it into individual file, use python:

with open('wikipages.csv', 'rb') as f:
  alltxt = f.read().split('\n@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n')

  for row in alltxt:
    one = row.split('\n')
    name = one[0].replace('/','-')
    try:
      del one[0]
      del one[0]
    except:
      continue
    txt = '\n'.join(one)
    of = open('/tmp/wikipages/' + name + '.txt', 'w')
    of.write(txt)
    of.close()

score 1 · Answer 1 · edited Apr 13 '17 at 12:22

1

In case you have some python knowledge you can utilize mwclient library to achieve this:

install Python 2.7 sudo apt-get install python2.7 ( see https://askubuntu.com/questions/101591/how-do-i-install-python-2-7-2-on-ubuntu in case of troubles )
install mwclient via pip install mwclient

run python script below

import mwclient
wiki = mwclient.Site(('http', 'you-wiki-domain.com'), '/')
for page in wiki.Pages:
  file = open(page.page_title, 'w')
  file.write(page.text())
  file.close()

see mwclient page https://github.com/mwclient/mwclient for reference

edited Apr 13 '17 at 12:22

Community

1
1

answered Oct 04 '16 at 01:42

wakalaka

524
4
12

There's also dumpgenerator.py with no history. – Nemo Dec 03 '16 at 21:24

score 0 · Answer 2 · answered Sep 24 '21 at 01:46

From Mediawiki version 1.35, multi-content revision model has been implemented, so the original dump code won't work correctly. Instead, you can use following code:

SELECT page_title, page_touched, old_text
FROM revision,page,text,content,slots
WHERE page.page_latest=revision.rev_id AND revision.rev_id=slots.slot_revision_id AND slots.slot_content_id=convert(substring(content.content_address,4),int) AND convert(substring(content.content_address,4),int)=text.old_id AND page_namespace!='6' AND page_namespace!='8' AND  page_namespace!='12'
INTO OUTFILE '/var/tmp/wikipages.csv' 
FIELDS TERMINATED BY '\n' 
ESCAPED BY ''
LINES TERMINATED BY '\n@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n';

How to export all pages from mediawiki into individual page files?

2 Answers2