On Tue, May 27, 2008 at 6:42 AM, howard chen <howachen(a)gmail.com> wrote:
Hi,
I am referring to the dump at:
http://download.wikimedia.org/zhwiki/20080425/
I can only find the categorylinks.sql.gz (only single level), but not
the full category
table which contains all the categories.
The category table, if that's what you really want, can be quickly
regenerated (if you have categorylinks) with the
maintenance/populateCategory.php script. This will give you different
category id's from those used on the real wikis, but category id's
aren't currently used elsewhere that I know of, so it shouldn't be a
problem for now. I don't know if the category table is explicitly
included in any of the dumps at present.
But I'm not sure if the category table is what you want. All its
contents are basically part of the categorylinks table, it's just a
summary table. If you mean the category *pages*, then as Domas says,
those are part of the page table, and should be available in the
pages-meta-current dump (or pages-meta-history if you prefer).