Page MenuHomePhabricator

Create partial SQL dump of logging table
Closed, DeclinedPublic

Description

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

  • log_id
  • log_type
  • log_action
  • log_timestamp
  • log_user
  • log_user_text
  • log_namespace
  • log_title
  • log_page
  • log_comment
  • log_params

This is every field in the logging table except log_deleted.


Version: unspecified
Severity: enhancement

Details

Reference
bz49134

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 1:47 AM
bzimport set Reference to bz49134.
MZMcBride created this task.Jun 4 2013, 3:15 PM

The pages-logging xml file contains these items already.

How do we go about fixing this bug?

Nemo_bis raised the priority of this task from Low to Medium.Apr 9 2015, 7:08 AM
Nemo_bis set Security to None.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 28 2015, 11:40 AM
ArielGlenn closed this task as Declined.Aug 5 2019, 12:18 PM

I'm going to decline this because we would have to walk through and decide which entries can be published and which ones not .
This should be done by letting MediaWiki do the work, rather than re-implementing the logic in the python scripts and needing to keep it in sync.
The pages-logging xml dumps already do that for us.

If sql format is essential, a task could be opened for a tool to convert the pages-logging xml files into sql format. Perhaps this could be added to mwdumper, for example.

ArielGlenn moved this task from Backlog to Done on the Dumps-Generation board.Dec 20 2019, 11:47 AM