Last modified: 2014-09-23 22:56:54 UTC
Created attachment 5486 [details] Dump category xml dumpBackup can currently export the wiki pages, full or current. r40968 added support for the logs and bug 16082 allows to include the authorship list on current dumps. But there's still one information needed for normal display not available yet on any xml: Categories. Unless you are to render every article, obtaining full information about a Category involves merging data from four different table dumps. The above patch addresses this by creating xml category dumps.
Created attachment 5487 [details] Structure of XML category dumps
Created attachment 5488 [details] Structure of XML category dumps
+need-review
Created attachment 5553 [details] Dump category xml New version, since the older didn't always achieve what it should. Still, it'd be nice to be able to get the hidden attribute in a more efficient way, specially if it worked with mysql 4.0. As it is now, <hidden> would be skipped on installs like wikipedia.
Picking this bug up as I'm the most likely to push it along.
Givng dump bugs to Ariel.
I'm pretty uneasy about running this complicated query with 4 tables and a subquery to boot, at least for full dumps. For manual exports of a small set of pages via Special:Export it might be just fine. Anyone with more query-fu than me want to weigh in?
(In reply to comment #4) > Created attachment 5553 [details] > Dump category xml Thanks for the patch. Would it be reasonable to put it into Gerrit?
Adding Asher for query-fu. :-)