Comparing the old XML database dump with the new MediaWiki Content File Exports dump:
- there are ~10,000 mainspaces pages that exist in the XML dump but not the ContentFileExport
- there are 11 mainspaces pages are in the ContentFileExport but not the old dump (the pages were deleted from the wiki between early December and late January)
- there are 2282 pages in the ContentFileExport that are missing the page text (I think this happened before with the old dumps and was fixed sometime in the last year).
- Some of these seem to be getting miscategorized as redirects
Download the files
wget https://dumps.wikimedia.org/enwiktionary/20260201/enwiktionary-20260201-pages-articles.xml.bz2 wget https://dumps.wikimedia.org/other/mediawiki_content_current/enwiktionary/2026-02-01/xml/bzip2/enwiktionary-2026-02-01-p6p11451351.xml.bz2
Check the sha sums against the published sums (they match)
sha1sum enwiktionary-20260201-pages-articles.xml.bz2 9a2274a328d56b33641322abd4bde64059c67309 enwiktionary-20260201-pages-articles.xml.bz2 sha256sum enwiktionary-2026-02-01-p6p11451351.xml.bz2 9b7a0d4f8563b7e5d77315347052e4f8336a88e820f4b36e7af758a5977ffd1c enwiktionary-2026-02-01-p6p11451351.xml.bz2
Crude method to dump mainspace titles
bzcat enwiktionary-2026-02-01-p6p11451351.xml.bz2 | grep '^ <title>' | grep -v ':' | pv -l > enwiktionary-2026-02-01-p6p11451351.xml.bz2.allpages bzcat enwiktionary-20260201-pages-articles.xml.bz2 | grep '^ <title>' | grep -v ':' | pv -l > enwiktionary-20260201-pages-articles.xml.bz2.allpages
Count pages in each dump
wc -l *allpages 8741706 enwiktionary-2026-02-01-p6p11451351.xml.bz2.allpages 8751224 enwiktionary-20260201-pages-articles.xml.bz2.allpages
First 10 pages that exist in the XML dump but not the ContentFileExport (these have existed for a long time on the wiki and should be in the dump)
diff enwiktionary-2026-02-01-p6p11451351.xml.bz2.allpages enwiktionary-20260201-pages-articles.xml.bz2.allpages | grep "^>" | head > <title>pie</title> > <title>A</title> > <title>fable</title> > <title>ability</title> > <title>abnegation</title> > <title>week</title> > <title>servant</title> > <title>second</title> > <title>perro</title> > <title>because</title>
Pages that exist in the ContentFileExport but not the XML dump (all deleted in December or January)
diff enwiktionary-2026-02-01-p6p11451351.xml.bz2.allpages enwiktionary-20260201-pages-articles.xml.bz2.allpages | grep "^<" < <title>A/translations</title> < <title>白苹</title> < <title>tiú</title> < <title>aẓermaḍ</title> < <title>wokenese</title> < <title>Ericsdott</title> < <title>barachoises</title> < <title>giggleshitter</title> < <title>bóina</title> < <title>chip sandwiches</title> < <title>𑀘𑁂𑀬𑁆𑀯𑀼</title>
Empty pages in the ContentFileExport
bzcat enwiktionary-20260201-pages-articles.xml.bz2 | grep '^ <text bytes="[^"]*" sha1="[^"]*" xml:space="preserve"></text>' | wc -l 2282
No empty pages in the XML dump
bzcat enwiktionary-2026-02-01-p6p11451351.xml.bz2 | grep '^ <text bytes="[^"]*" sha1="[^"]*" xml:space="preserve"></text>' | wc -l 0
Sample of an empty page misclassified as a redirect in the ContentFileExport
bzcat enwiktionary-2026-02-01-p6p11451351.xml.bz2 | grep -B1 -A20 '<title>Template:wikipedia inline</title>'
<page>
<title>Template:wikipedia inline</title>
<ns>10</ns>
<id>71571</id>
<redirect title="Template:pedia" />
<revision>
<id>87466915</id>
<parentid>82601960</parentid>
<timestamp>2025-10-17T17:56:34Z</timestamp>
<contributor>
<username>Juwan</username>
<id>3726457</id>
</contributor>
<minor />
<comment>Juwan moved page [[Template:pedia]] to [[Template:wikipedia inline]]: Standardize title: [[Wiktionary:Grease pit/2025/September#Cleanup of interwiki templates]]</comment>
<origin>67951436</origin>
<model>wikitext</model>
<format>text/x-wiki</format>
<text bytes="134" sha1="2b9gh7qf7g5eo9oi85oc5p8kyhobye9" xml:space="preserve"></text>
<sha1>2b9gh7qf7g5eo9oi85oc5p8kyhobye9</sha1>
</revision>
</page>Same page in the XML dump includes page content and is not a redirect
bzcat enwiktionary-20260201-pages-articles.xml.bz2 | grep -B1 -A20 '<title>Template:wikipedia inline</title>'
<page>
<title>Template:wikipedia inline</title>
<ns>10</ns>
<id>71571</id>
<revision>
<id>87466915</id>
<parentid>82601960</parentid>
<timestamp>2025-10-17T17:56:34Z</timestamp>
<contributor>
<username>Juwan</username>
<id>3726457</id>
</contributor>
<minor />
<comment>Juwan moved page [[Template:pedia]] to [[Template:wikipedia inline]]: Standardize title: [[Wiktionary:Grease pit/2025/September#Cleanup of interwiki templates]]</comment>
<origin>67951436</origin>
<model>wikitext</model>
<format>text/x-wiki</format>
<text bytes="134" sha1="2b9gh7qf7g5eo9oi85oc5p8kyhobye9" xml:space="preserve">{{#invoke:interproject|projectlink|prefix=w|name=Wikipedia|image=Wikipedia-logo.svg|compat=1}}<noinclude>{{documentation}}</noinclude></text>
<sha1>2b9gh7qf7g5eo9oi85oc5p8kyhobye9</sha1>
</revision>
</page>