Create partial SQL dump of user table
Open, MediumPublicFeature
Actions

Assigned To

None

Authored By

	• MZMcBride
	Jun 4 2013, 3:09 PM

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

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T140977 Dump public data from all sql tables that have mixed public/private data
		Open	Feature	None	T51132 Create partial SQL dump of user table

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 22 2014, 1:47 AM

• bzimport added a project: Datasets-General-or-Unknown.

• bzimport set Reference to bz49132.

• MZMcBride created this task.Jun 4 2013, 3:09 PM

Nemo_bis awarded a token.Dec 12 2014, 8:05 AM

Nemo_bis raised the priority of this task from Low to Medium.Apr 9 2015, 7:08 AM

Nemo_bis set Security to None.

ArielGlenn edited projects, added Dumps-Generation; removed Datasets-General-or-Unknown.Sep 28 2015, 11:41 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 28 2015, 11:41 AM

ArielGlenn removed a parent task: T27602: Create SQL dumps for certain database tables, partial if necessary (tracking).Jul 14 2016, 7:21 PM

Nemo_bis rescinded a token.Jul 16 2016, 8:00 AM

Nemo_bis awarded a token.Jul 16 2016, 8:03 AM

• MZMcBride mentioned this in T27602: Create SQL dumps for certain database tables, partial if necessary (tracking).Jul 20 2016, 7:21 AM

ArielGlenn added a parent task: T140977: Dump public data from all sql tables that have mixed public/private data.Jul 21 2016, 9:35 AM

Halfak merged a task: T181720: Create user table SQL dump.Nov 30 2017, 2:50 PM

Halfak added subscribers: Halfak, ArielGlenn.

RoySmith subscribed.Jul 11 2021, 2:20 AM

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

In T51132#7203364, @Legoktm wrote:

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.

RoySmith mentioned this in T286488: Create a one-off dump of enwiki user table.Jul 12 2021, 3:45 PM

@ArielGlenn: Hi, I'm resetting the task assignee due to inactivity. Please feel free to reclaim this task if you plan to work on this - it would be welcome! Also see https://www.mediawiki.org/wiki/Bug_management/Assignee_cleanup for more information - thanks!

Aklapper changed the subtype of this task from "Task" to "Feature Request".Feb 4 2022, 12:24 PM

Create partial SQL dump of user tableOpen, MediumPublicFeatureActions

Description

Details

Related ObjectsSearch...

Event Timeline

Create partial SQL dump of user table
Open, MediumPublicFeature
Actions

Related Objects
Search...