If you are just trying to get at the structure from the various dump files, the page table has page ids, titles, and whether the page is a redirect or not (*-page.sql.gz), the category table has category names, ids, and summary information (*-category.sql.gz), and categorylinks has the list of all category links in a page, with the page id and the category name (*-categorylinks.sql.gz). You can find details on the tables here: http://www.mediawiki.org/wiki/Manual:Categorylinks_table (here's the category: http://www.mediawiki.org/wiki/Category:MediaWiki_database_tables )
Hopefully this should get you started.
Ariel
Στις 09-01-2013, ημέρα Τετ, και ώρα 10:51 -0800, ο/η Robert Crowe έγραψε:
I'd like to mirror just the category structure of the English Wikipedia, and I'm wondering which of the dump files I need to start with.
I don't need the page content, just the page names, and only for the most current revision. I need the categories and category members, and I'd like to exclude hidden categories. I also need to distinguish redirects, because I don't want to treat them as separate pages. As much as possible I'd like to work with SQL files, but I can crunch through XML if necessary.
So which files do I need to download? I may also need some help in understanding the schemas.
Thanks,
Robert
Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l