Hi everyone!
I'm trying to load the dumps into my mysql database, but so far for the revision and page tables, I get either null or zero values for the rev_len and page_len columns. Does anybody have any idea why? What dump file contains this information?
Thanks!
How did you load the dumps?
From my experience, mwdumper does fill page_len, but not rev_len.
If you want to fill rev_len, you can run the maintenance script maintenance/populateRevisionLength.php on your wiki. It seems there isn't a similar script for page_len.
Petr Onderka [[en:User:Svick]]
On Thu, Aug 22, 2013 at 4:20 PM, Xavier Vinyals Mirabent vinya002@umn.eduwrote:
Hi everyone!
I'm trying to load the dumps into my mysql database, but so far for the revision and page tables, I get either null or zero values for the rev_len and page_len columns. Does anybody have any idea why? What dump file contains this information?
Thanks!
-- Xavi
Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l
On 22/08/13 18:29, Petr Onderka wrote:
How did you load the dumps?
From my experience, mwdumper does fill page_len, but not rev_len. If you want to fill rev_len, you can run the maintenance script maintenance/populateRevisionLength.php on your wiki. It seems there isn't a similar script for page_len.
Petr Onderka [[en:User:Svick]]
That's because page_len has been around for ages.
Once you have rev_len updated, you could set page_len by running:
UPDATE page JOIN revision ON (page_latest=rev_id) SET page_len=rev_len;
xmldatadumps-l@lists.wikimedia.org