Allow Ckepper to retrieve a backup of the Books namespace
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	• Elitre
	Jun 15 2023, 4:32 PM

Description

@Ckepper , the person behind the Book Creator, "would be interested in retrieving a backup of the complete books namespace for future reference (my idea is to use this data as part of an auto-suggest feature)."
The namespace was deleted from en.wp in 2021, and there's a message saying "individual books will be restored upon request", but we're talking about many, many books here.

If anyone wants to volunteer to make this happen or provide advice, that'd be appreciated.
(I've already investigated internally and I've been told "mass undeleting (temporarily) could make our DBA's cry", FWIW.)

Event Timeline

• Elitre created this task.Jun 15 2023, 4:32 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 15 2023, 4:32 PM

select ar_title, ar_timestamp, ar_rev_id from archive where ar_namespace = 4 and ar_title LIKE 'Books/archive/%' GROUP BY ar_title ORDER BY ar_title, MAX(ar_timestamp);

Noting there are 6740 rows/pages...

Allow Ckepper to retrieve a backup of the Books namespaceOpen, Needs TriagePublicActions

Description

Event Timeline

Allow Ckepper to retrieve a backup of the Books namespace
Open, Needs TriagePublic
Actions