Hi Domas & Simetrical,
The category table, if that's what you really
want, can be quickly
regenerated (if you have categorylinks)
The problem I found is : seems categorylinks is out-of-sync with the
category current showing on wikipedia (zhwiki at least, I haven't test
other languages)
For example, a singer in Hong Kong, Leon Lai
http://zh.wikipedia.org/w/index.php?title=%E9%BB%8E%E6%98%8E&variant=zh…
at the bottom, you would find he is belonged to 11 categories,
however, I run the SQL against (categorylinks.sql,
http://download.wikimedia.org/zhwiki/latest/zhwiki-latest-categorylinks.sql…
)
SELECT * FROM `categorylinks` WHERE `cl_sortkey` ='黎明';
I can only get 2 categories (Note: The queried name is the same in
both Traditional & Simplified Chinese, even I looked back to a version
in 2007, it also contains 11 categories.
)
Now, I query one of the category within the 11 category which not
appear in above,
SELECT * FROM `categorylinks` WHERE `cl_to` LIKE '1966年出生';
I get 177 rows, which the wikipedia showing 185 items
(
http://zh.wikipedia.org/wiki/Category:1966%E5%B9%B4%E5%87%BA%E7%94%9F)
The only reason I can think of is those pages are all human edited,
and it might not be reflected in categorylinks table.
Howard