Topic on Talk:Quarry

Which file in the Wikipedia dumps corresponds to the "revision" table?

2
Gatherinfer (talkcontribs)

I need to download the entire revision history of English Wikipedia (the metadata for each edit, not the content itself). On Quarry, that's the "revision" table. However I can't download it from Quarry because it's too big. I looked in the Wikipedia dumps site:


https://dumps.wikimedia.org/enwiki/20181201/


And I wasn't sure which file or set of files I need. I can see files corresponding to some of the tables I can query (e.g. user_groups.sql, redirect.sql, etc) but I can't find one named revision.sql or similar.

There are two collections of files, both of which have "These files contain no page text, only revision metadata." in the subheading. Is one of these the one I need? If so, which one? I don't want to download many gigabytes of files only to find I chose the wrong one ..

Thankyou.

BDavis (WMF) (talkcontribs)
Reply to "Which file in the Wikipedia dumps corresponds to the "revision" table?"