Do you want complete removal of the old revisions, or do you just want to hide them from the history?
If the latter...
1. Delete the page 2. Go to the undelete page (Special:Undelete/Pagename) 3. Scroll down and check the topmost box 4. Click Restore
This restores the latest revision from the deletion archives, but will keep the old revisions hidden from non-sysops.
Rob Church
On 30/12/05, Sy Ali sy1234@gmail.com wrote:
On 12/29/05, Rob Church robchur@gmail.com wrote:
Undelete the pages; yes, undelete. Then nip into the page table and find out the page id...delete that page's row from the page table. Hop over to the revisions table and delete all rows where rev_page is the same as that page id. That's a permanent deletion; the page never existed.
For the small touches, check that corresponding revisions are wiped from the recent changes table, too.
Is there wiki-side documentation on spelunking around the database like this? I don't know where to begin looking. (the mediawiki hacking topics?)
This looks like it's only good for totally nuking a complete page, can it be varied to delete the history of a particular page and leave the the present revision intact? I understand that it might not work that way now (with revisions being tracked, and not complete page copies).
This stuff wouldn't work for bulk stuff as-is, but if it's simple enough I could pull off some Ruby scripting it if there were some nice mysql tools for Ruby (I'm not sure). That, and I know some people I can pay to do it and test it if need be. =) _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l