I've imported the wikipedia database in four languages with the goal of running some machine learning algorithms on it for text classification. The import doesn't populate the "category" table though. Am I missing something?

I would also like to know if there was a way to map categories across the different language databases? i.e. know which category in English represents which category in German for example?


  • 1
    It turns out I imported the articles only (using mwdumper). The categories (as well as the pages) and other table dumps can be downloaded here: dumps.wikimedia.org/enwiki/latest. "en" can be replaced with the desired language code.
    – podzway
    Commented Mar 8, 2016 at 11:05

1 Answer 1


For the second question, the answer is in the langlinks table (categories have page_id just like pages). Se more here: https://www.mediawiki.org/wiki/Manual:Langlinks_table

  • Anyway beware that structure of categories is different in different Wikipedias and this makes mapping categories between Wikipedias harder than mapping articles.
    – Pere
    Commented Mar 4, 2017 at 17:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.