enwiki-latest-category.sql

dumps.wikimedia.org/enwiki/latest/enwiki-latest-category.sql.gz contains a list of categories. It only contains the categories and some counts, but it doesn't contain the subcategories and pages under each category, so it is a bit pointless.

The schema is listed at: www.mediawiki.org/wiki/Manual:Category_table

The SQL first defines the table:

CREATE TABLE `category` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_title` varbinary(255) NOT NULL DEFAULT '',
  `cat_pages` int(11) NOT NULL DEFAULT 0,
  `cat_subcats` int(11) NOT NULL DEFAULT 0,
  `cat_files` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`cat_id`),
  UNIQUE KEY `cat_title` (`cat_title`),
  KEY `cat_pages` (`cat_pages`)
) ENGINE=InnoDB AUTO_INCREMENT=249228235 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED;

followed by a few humongous inserts:

INSERT INTO `category` VALUES (2,'Unprintworthy_redirects',1597224,20,0),(3,'Computer_storage_devices',88,11,0)

which we can see at: en.wikipedia.org/wiki/Category:Computer_storage_devices

Se see that en.wikipedia.org/wiki/Category:Computer_storage_devices_by_company

en.wikipedia.org/wiki/Category:Computer_storage_devices is a subcategory of that category and it appears in that file.
en.wikipedia.org/wiki/Acronis_Secure_Zone is a page of the category, and it does not appear

so it contains only categories.

We can check this with:

sed -s 's/),/\n/g' enwiki-latest-category.sql | grep Computer_storage_devices

and it shows:

(3,'Computer_storage_devices',88,11,0
(521773,'Computer_storage_devices_by_company',6,6,0

There doesn't seem to be any interlink between the categories, only page and subcategory counts therefore.

enwiki-latest-category.sql

 Ancestors (8)