Page MenuHomePhabricator

Create partial SQL dump of user table
Open, MediumPublic

Description

Create a partial SQL dump of the user table that includes:

  • user_id
  • user_name
  • user_editcount
  • user_registration

Version: unspecified
Severity: enhancement

Details

Reference
bz49132

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 1:47 AM
bzimport set Reference to bz49132.
Nemo_bis raised the priority of this task from Low to Medium.Apr 9 2015, 7:08 AM
Nemo_bis set Security to None.

A partial dump of the user table should probably follow the same query that the wikireplicas do to exclude hidden (suppressed) users: https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+/3cab56ecbf9af41c7bd5451c04660cf1a50550ec/modules/profile/templates/wmcs/db/wikireplicas/maintain-views.yaml#811

Thanks foe this, it will be useful. We'll need to avoid some columns that shouldn't be public as well. It will need some thought.