Xmldatadumps-l June 2022

xmldatadumps-l@lists.wikimedia.org

3 participants
3 discussions

Re: changes to Page table?
by Hannah Okwelum 14 Jun '22

14 Jun '22

Hello Carley, the page_restrictions column is no longer used within MediaWiki, see https://phabricator.wikimedia.org/T218446 The column is being removed from the page table, a change that is almost complete; you can track the progress of that here https://phabricator.wikimedia.org/T60674 if you are interested. You can use the page_restrictions table instead. The Manual page you refer to will likely be updated once the schema change is complete. Thank you, Hannah Okwelum

1 0

changes to Page table?
by Carley Zepeda 14 Jun '22

14 Jun '22

Hello, I think a column was removed from the page DDL but I'm not sure if it was intentional because I didn't see any postings and the online documentation still refers to it. Can someone confirm the column has been dropped/removed? I don't want to make changes on my end if it was done by mistake. The column is page_restrictions <https://www.mediawiki.org/wiki/Manual:Page_table#page_restrictions> I see the note about it being empty but when I download one of the latest files and review the DDL, it's no longer in the table definition -- Link to file I downloaded for yowiki-latest-page.sql.gz <https://dumps.wikimedia.your.org/yowiki/latest/yowiki-latest-page.sql.gz> I downloaded an earlier version from https://dumps.wikimedia.your.org/yowiki/20220520/ and compared them -- the DDL sections for yowiki-20220520-page.sql.gz <https://dumps.wikimedia.your.org/yowiki/20220520/yowiki-20220520-page.sql.gz> vs yowiki-20220601-page.sql.gz <https://dumps.wikimedia.your.org/yowiki/20220601/yowiki-20220601-page.sql.gz> is in the screenshot below, with page_restrictions highlighted on the left (MAY file). [image: Screen Shot 2022-06-13 at 2.25.13 PM.png] https://meta.wikimedia.org/wiki/Data_dumps/Dump_format#Format_of_the_sql_fi… Thank you, CJZee

1 0

XML Dumps FAQ monthly update
by noreply.xmldatadumps＠wikimedia.org 02 Jun '22

02 Jun '22

Greetings XML Dump users and contributors! This is your automatic monthly Dumps FAQ update email. This update contains figures for the 20220501 full revision history content run. We are currently dumping 948 projects in total. --------------------- Stats for srnwiki on date 20220501 Total size of page content dump files for articles, current content only: 3,819,579 Total size of page content dump files for all pages, current content only: 5,442,150 Total size of page content dump files for all pages, all revisions: 210,326,461 --------------------- Stats for enwiki on date 20220501 Total size of page content dump files for articles, current content only: 88,902,717,881 Total size of page content dump files for all pages, current content only: 195,143,033,220 Total size of page content dump files for all pages, all revisions: 24,683,031,783,592 --------------------- Sincerely, Your friendly Wikimedia Dump Info Collector

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Xmldatadumps-l June 2022