Page MenuHomePhabricator

Add central auth sql dumps
Closed, ResolvedPublic

Description

Per request of Erik Zachte lets add dumps of the central auth database. Since central auth is its own database the xml snapshots code will need to have a way of knowing to ignore all the regular public/private wiki's and instead dump the specifically mentioned tables.

Perhaps each type of dump could have a template for what gets dumped.

One for the regular set of tables and another for specific databases. We already somewhat do this with FlaggedRevs and isBig wikis.


Version: unspecified
Severity: enhancement

Details

Reference
bz25579

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:22 PM
bzimport set Reference to bz25579.

Quick note. Any central auth sql dumps should be placed into the private space.

erikzachte wrote:

Although some day xml format would be ideal, being more decoupled from database changes, for now a MySQL export will be fine (like happens for some other tables, the one stored as ..sql.gz). I will do the parsing myself. Thanks

These run every week by cron and are written to private/centralauth as sql.gz files. Closing.