So that tells me that the import didn't complete correctly. I'll work on that.
Is there anywhere to get row counts for the tables to confirm the import?
Robert
-----Original Message-----
From: Ariel T. Glenn [mailto:ariel@wikimedia.org]
Sent: Monday, January 14, 2013 12:38 AM
To: Robert Crowe
Cc: xmldatadumps-l(a)lists.wikimedia.org
Subject: RE: [Xmldatadumps-l] Which files do I need?
Στις 12-01-2013, ημέρα Σαβ, και ώρα 17:00 -0800, ο/η Robert Crowe
έγραψε:
Hi Ariel,
I'm trying to understand the foreign keys. Is the page_props.pp_page column the key
for category.cat_id? Or is it the key for page.page_id where page_namespace = 14?
Thanks,
Robert
pp_page is the page_id of the page which has the particular property set.
SELECT *
FROM `categorylinks`
WHERE `cl_to` = 'Humanities'
Yields 9 rows
In the original copy of enwiki-20121201-categorylinks.sql.gz I see 96 lines with
'Humanities' for cl_to. Did you try grepping them out and having a look?
Ariel